ORA-12072: updatable materialized view log data for "string"."string" cannot be created

Cause : The udpatabl ematerailizedv iew wsa missnig theu pdatalbe matreializde viewl og reuqired ot trac kupdatse madet o them aterilaized ivew.

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

Creat ean upadtablem aterilaized ivew lo.g

update : 25-04-2017

ORA-12072 - updatable materialized view log data for "string"."string" cannot be created
ORA-12072 - updatable materialized view log data for "string"."string" cannot be created

  • ora-02359 : internal error setting attribute string
  • ora-23402 : refresh was aborted because of conflicts caused by deferred txns
  • ora-24334 : no descriptor for this position
  • ora-16617 : unknown object identifier specified in request
  • ora-06928 : CMX: wrong ORACLE_SID
  • ora-28201 : Not enough privileges to enable application role 'string'
  • ora-02771 : Illegal request time out value
  • ora-25017 : cannot reference NEW ROWID for movable rows in before triggers
  • ora-25455 : evaluation error for rule set: string.string, evaluation context: string.string
  • ora-19999 : skip_row procedure was called
  • ora-30190 : reserved for future use
  • ora-13839 : V$SQL row doesn't exist with given HASH_VALUE and ADDRESS.
  • ora-14326 : Primary index on an IOT, DOMAIN and LOB indexes may not be specified in the UPDATE INDEXES clause
  • ora-00356 : inconsistent lengths in change description
  • ora-02455 : The number of cluster key column must be 1
  • ora-26058 : unexpected error fetching metadata for column string in table string
  • ora-17622 : failed to deregister the memory with Oracle Disk Manager library
  • ora-01563 : rollback segment is PUBLIC, need to use the keyword PUBLIC
  • ora-28277 : LDAP search, while authenticating global user with passwords, failed.
  • ora-02763 : Unable to cancel at least one request
  • ora-02426 : privilege grant failed
  • ora-36958 : (XSFCAST26) The OFFSET value for cycle number cannot be greater than the cycle's PERIODICITY, which is number. You specified number.
  • ora-01173 : data dictionary indicates missing data file from system tablespace
  • ora-04091 : table string.string is mutating, trigger/function may not see it
  • ora-40205 : invalid setting name string
  • ora-28178 : password not provided by proxy
  • ora-36976 : (XSRELGID00) The format of the GROUPINGID command is: GROUPINGID [relation1] INTO {variable | relation2 | surrogate} [USING levelrelation] [INHIERARCHY {inhvariable | valueset}] [LEVELORDER levelordervs] The source relation can be omitted only when using both surrogate gid and level order valueset.
  • ora-30677 : session is already connected to a debugger
  • ora-29703 : error occurred in global enqueue service operation
  • ora-32633 : MODEL subquery FOR cell index returns too many rows
  • 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.