ORA-23474: definition of ... has changed since generation of replic
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-23474: definition of ... has changed since generation of replic

  1. #1
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316

    Question ORA-23474: definition of ... has changed since generation of replic

    We exported/imported some PROD objects into DEV database.
    Now I am not able to update the table below.

    There are no replication master groups setup !

    delete from idt_clearing where rownum < 11
    *
    ERROR at line 1:
    ORA-23474: definition of "FACT"."IDT_CLEARING" has changed since generation of replication support

    What views should I check to see what is going on ? And if there are any other objects in this state ?
    How do I clear this object ?

  2. #2
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    I just checked all the v$ and dba_ replication related views. Nothing is setup for replication, no errors in alertlog !

    Any ideas any one ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width