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-13287: can't transform unknown gtype

1 Answers  


TNS-01064: Listener configuration changes will not be persistent

1 Answers  


ORA-22295: cannot bind more than 4000 bytes data to LOB and LONG columns in 1 statement

1 Answers  


ORA-19596: SPFILE already included

1 Answers  


ORA-40221: maximum target cardinality exceeded

1 Answers  


ORA-01215: enabled thread string is missing after CREATE CONTROLFILE

1 Answers  


ORA-09984: SGA file $ORACLE_HOME/dbs/sgadef$ORACLE_SID.dbf does not exist

1 Answers  


ORA-28234: key length too short

1 Answers  


PCB-00236: Cannot use PIC N/G variable. NLS_NCHAR not set or set incorrectly.

1 Answers  


SQL*Loader-00507: unexpected EOF reading SDF or LOBFILE string for column string in table string

1 Answers  


TNS-12647: Authentication required

1 Answers  


PLS-00381: type mismatch found at 'string' between column and variable in subquery or INSERT

1 Answers  


Categories