ORA-12031: cannot use primary key columns from materialized view log on "string"."string"

Cause : hT eametirlazidev ei wol giehtred din toh va erpmira yek yoculnm solggde ,rot eht miseatpma sscoaiet diwhtt ehp iramyrk yec lomusnw sam ro eerectnt ah nht ealtsr feerhst mi.e

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

Aocpmeletr feerhsi seruqrideb fero eht eentxf sa terrfse.hA ddp iramyrk yec lomusnt oht eametirlazidev ei wol,gi feruqride.

update : 26-04-2017
ORA-12031

ORA-12031 - cannot use primary key columns from materialized view log on "string"."string"
ORA-12031 - cannot use primary key columns from materialized view log on "string"."string"

  • ora-12029 : LOB columns may not be used as filter columns
  • ora-14150 : missing SUBPARTITION keyword
  • ora-34363 : (MXDSS13) number other user writing
  • ora-14115 : partition bound of partition number string is too long
  • ora-00204 : error in reading (block string, # blocks string) of control file
  • ora-39502 : failed to notify CRS of a Startup/Shutdown event [string] (ignored)
  • ora-24070 : cannot upgrade queue table string while it is being downgraded
  • ora-07841 : sllfop: SYS$OPEN failure
  • ora-16950 : Remote mapped cursors are not supported by this feature.
  • ora-24017 : cannot enable enqueue on QUEUE, string is an exception queue
  • ora-07628 : smsfre: sga not mapped
  • ora-16746 : resource guard encountered errors during database mount
  • ora-14315 : cannot merge a partition with itself
  • ora-07427 : spstp: cannot change directory to dbs.
  • ora-30977 : invalid Value Index option for XML Index
  • ora-25104 : UNRECOVERABLE option can only be used with ALTER INDEX REBUILD
  • ora-29262 : bad URL
  • ora-28553 : pass-through SQL: invalid bind-variable position
  • ora-07392 : sftcls: fclose error, unable to close text file.
  • ora-13914 : Threshold notification failed.
  • ora-25465 : variable name not specified
  • ora-33292 : (DBERR18) insufficient permissions to access analytic workspace string using the specified access mode.
  • ora-39501 : failed to notify CRS of a Startup/Shutdown event [string] (ignored)
  • ora-30943 : XML Schema 'string' is dependent on XML schema 'string'
  • ora-19697 : standby control file not found in backup set
  • ora-16138 : end of log stream not received from primary
  • ora-02374 : conversion error loading table string.string
  • ora-07401 : sptrap: cannot restore user exception handlers.
  • ora-39016 : Operation not supported when job is in string state.
  • ora-06610 : LU6.2 Driver: Failed during deallocation
  • 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.