ORA-23412: master table's primary key columns have changed

Cause : hT eamtsret baels'p iramyrk yec notsarni taw somidifdea tfret ehp iramyrk yem tareaiilez divwew sac ertade.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

rDpoa dnr ceerta eht erpmira yek yametirlazidev eiw

update : 18-08-2017
ORA-23412

ORA-23412 - master table's primary key columns have changed
ORA-23412 - master table's primary key columns have changed

  • ora-12215 : TNS:poorly formed PREFERRED_NAVIGATORS Addresses in TNSNAV.ORA
  • ora-23290 : This operation may not be combined with any other operation
  • ora-29355 : NULL or invalid string argument specified
  • ora-29256 : Cursor contains both regular and array defines which is illegal
  • ora-37145 : (XSTTS_PLAT) Cannot transport analytic workspace across platforms.
  • ora-28052 : the account is disabled
  • ora-24087 : Invalid database user string
  • ora-00207 : control files are not for the same database
  • ora-22053 : overflow error
  • ora-02149 : Specified partition does not exist
  • ora-24440 : OCI Easy Install mode cannot be initialized
  • ora-28274 : No ORACLE password attribute corresponding to user nickname exists.
  • ora-31467 : no column found in the source table
  • ora-14083 : cannot drop the only partition of a partitioned table
  • ora-16521 : unable to create generic template id
  • ora-19227 : XP0007 - fn:data function is applied to a node (type (string)) whose type annotation denotes a complex type with non-mixed complex content.
  • ora-07800 : slbtpd: invalid number
  • ora-36764 : (XSAGGCNTMOVE02) AGGCOUNT variable workspace object must be of type INTEGER, not string.
  • ora-22292 : Cannot open a LOB in read-write mode without a transaction
  • ora-16064 : remote archival is disabled by another instance
  • ora-12159 : TNS:trace file not writeable
  • ora-24152 : cannot drop evaluation context string.string with dependents
  • ora-19123 : fn:zero-or-one() called with a sequence containing more than one item
  • ora-32057 : invalid lock mode
  • ora-40217 : priors table mismatched with training data
  • ora-01414 : invalid array length when trying to bind array
  • ora-23393 : the user is already the propagator
  • ora-19701 : device name exceeds maximum length of string
  • ora-27045 : unable to close the file
  • ora-00316 : log string of thread string, type string in header is not log file
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.