ORA-12035: could not use materialized view log on "string"."string"

Cause : The amterilaizedv iew olg di dnot xeist ro coudl notb e usde.

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

Use ujst RFERESH ,whic hwillr einsatntiaet thee ntir etabl.e If amateiralizde vie wlog xeistsa nd teh for mof teh matreialiezd viwe allwos th euse fo a mtaeriailzed ivew lgo, RERFESH AFST wlil bea vailbale satrtin gthe enxt tmie th emateiralizde vie wis rfereshde.

update : 26-04-2017
ORA-12035

ORA-12035 - could not use materialized view log on "string"."string"
ORA-12035 - could not use materialized view log on "string"."string"

  • ora-09760 : osnpui: cannot send break message
  • ora-13120 : invalid face_id [string]
  • ora-30373 : object data types are not supported in this context
  • ora-39033 : Data cannot be filtered under the direct path access method.
  • ora-16152 : standby database is in 'no-data-loss' protected mode
  • ora-29848 : error occurred in the execution of ODCIINDEXMERGEPARTITION routine
  • ora-38776 : cannot begin flashback generation - flash recovery area is disabled
  • ora-06519 : active autonomous transaction detected and rolled back
  • ora-09943 : Allocation of memory for password list component failed.
  • ora-16957 : SQL Analyze time limit interrupt
  • ora-25155 : column used in NATURAL join cannot have qualifier
  • ora-40254 : priors cannot be specified for one-class models
  • ora-32155 : Anydata not specified
  • ora-12821 : invalid value for INSTANCES
  • ora-14281 : CHECK constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION
  • ora-28334 : column is already encrypted
  • ora-31067 : XML nodes must be updated with valid nodes and of the same type
  • ora-08462 : raw buffer contains invalid decimal data
  • ora-16146 : standby destination control file enqueue unavailable
  • ora-24393 : invalid mode for creating connection pool
  • ora-23440 : incorrect public template value
  • ora-37128 : (XSCCOMP03) It is not possible to PARTITION over a base of a COMPRESSED COMPOSITE.
  • ora-13856 : Service name must be specified
  • ora-06979 : X.25 Driver: server cannot start oracle
  • ora-14103 : LOGGING/NOLOGGING may not be combined with RECOVERABLE/UNRECOVERABLE
  • ora-01343 : LogMiner encountered corruption in the logstream
  • ora-31651 : communication error with master process - detaching job
  • ora-25266 : didnt try to dequeue by message id. with the signature
  • ora-32802 : value for string must be string
  • ora-26041 : DATETIME/INTERVAL datatype conversion error
  • 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.