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

PLS-01711: A SELECT statement may not contain ORDER_BY, HAVING, or GROUP_BY clause

1 Answers  


ORA-23367: table string is missing the primary key

1 Answers  


ORA-02302: invalid or missing type name

1 Answers  


DRG-50304: error in execute()

1 Answers  


ORA-19640: datafile checkpoint is SCN string time string

1 Answers  






CLSR-00508: Invalid message number number

1 Answers  


PLS-00366: subtype of a NOT NULL type must also be NOT NULL

1 Answers  


ORA-13137: failed to generate tablespace sequence number

1 Answers  


TNS-00093: argument is only supplied to either status or trace_on

1 Answers  


ORA-35280: (SNSYN165) The format of the AGGREGATE command is: AGGREGATE varname1 [varname2 varname3 ...] USING aggmap-name [COUNTVAR intvar-name1 [intvar-name2 intvar-name3 ...]] [FUNCDATA] [THREADS #]

1 Answers  


ORA-14323: cannot add partition when DEFAULT partition exists

1 Answers  


ORA-10567: Redo is inconsistent with data block (file# string, block# string)

1 Answers  


Categories