ORA-12010: cannot create materialized view log on table
owned by SYS



ORA-12010: cannot create materialized view log on table owned by SYS..

Answer / guest

Cause: An attempt was made to create a materialized view log
on the table owned by SYS. CREATE MATERIALIZED VIEW LOG
attempts to create a trigger on the table, but triggers can
not be created on SYS tables.

Action: Do not create a materialized view log on SYS tables.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

SQL*Loader-00914: Error locking table string in exclusive mode.

1 Answers  


ORA-33016: (XSAGDNGL07) In AGGMAP workspace object, workspace object is not a valid operator or variable name.

1 Answers  


PCC-02106: Userid only used when SQLCHECK = FULL, userid ignored.

1 Answers  


NNO-00258: cannot load configuration from configuration database

1 Answers  


ORA-27199: skgfpst: sbtpcstatus returned error

1 Answers  


TNS-12537: TNS:connection closed

1 Answers   IBM,


ORA-16083: LogMiner session has not been created

1 Answers  


ORA-31521: CDC subscription string already subscribes to publication ID string column string

1 Answers  


ORA-19753: error writing to change tracking file

1 Answers  


ORA-13017: unrecognized line partition shape

1 Answers  


RMAN-12012: multiple records for string parallelism found in catalog

1 Answers  


NZE-29240: the cryptographic engine does not recognize the algorithm

1 Answers  


Categories