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

ORA-32057: invalid lock mode

1 Answers  


DRG-11528: LONG or LONG RAW column defintion found in structure data

1 Answers  


ORA-13454: GeoRaster metadata is invalid

1 Answers  


ORA-29951: warning in the execution of ODCIINDEXSPLITPARTITION routine

1 Answers  


ORA-27141: invalid process ID

1 Answers  






RMAN-20011: target database incarnation is not current in recovery catalog

1 Answers  


RMAN-00601: fatal error in recovery manager

1 Answers  


ORA-15183: ASMLIB initialization error [string]

1 Answers  


ORA-30688: maximum program calling depth exceeded

1 Answers  


ORA-31077: invalid attribute "string" specified

1 Answers  


NNL-00954: Hash tables created: number

1 Answers  


ORA-01086: savepoint 'string' never established

1 Answers  


Categories