ORA-12022: materialized view log on "string"."string" already has rowid

Cause : Materialized view log on the indicated table already has ROWID information.

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

No action required.

update : 24-07-2017
ORA-12022

ORA-12022 - materialized view log on "string"."string" already has rowid
ORA-12022 - materialized view log on "string"."string" already has rowid

  • ora-26754 : cannot specify both one-to-one transformation function string and one-to-many transformation function string
  • ora-16769 : the physical standby database is open read-only
  • ora-13224 : zero tolerance specified for layer in USER_SDO_GEOM_METADATA
  • ora-09762 : sNeXT_instanceName: translation error.
  • ora-39130 : Object type string not imported. Base object name conflicts with the master table
  • ora-14047 : ALTER TABLE|INDEX RENAME may not be combined with other operations
  • ora-12442 : policy column "string" already used by an existing policy
  • ora-26026 : unique index string.string initially in unusable state
  • ora-16501 : the Data Guard broker operation failed
  • ora-30654 : missing DEFAULT keyword
  • ora-29967 : Cannot drop an operator binding with dependent objects
  • ora-01039 : insufficient privileges on underlying objects of the view
  • ora-06564 : object string does not exist
  • ora-12500 : TNS:listener failed to start a dedicated server process
  • ora-06254 : NETNTT: cannot share connection to cube
  • ora-14196 : Specified index cannot be used to enforce the constraint.
  • ora-01138 : database must either be open in this instance or not at all
  • ora-06121 : NETTCP: access failure
  • ora-13526 : baseline (string) does not exist
  • ora-15014 : location 'string' is not in the discovery set
  • ora-00972 : identifier is too long
  • ora-01343 : LogMiner encountered corruption in the logstream
  • ora-32821 : subscriber queue and exception queue must have same payload type
  • ora-24049 : invalid agent name string, names with AQ$_ prefix are not valid
  • ora-25007 : functions or methods not allowed in WHEN clause
  • ora-12712 : new character set must be a superset of old character set
  • ora-36808 : (XSTBLFUNC04) The OLAP_TABLE function LEVELREL clause cannot declare number ADT fields from number AW fields.
  • ora-19701 : device name exceeds maximum length of string
  • ora-13187 : subdivision failed
  • ora-12821 : invalid value for INSTANCES
  • 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.