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-31398: DBMS_LDAP: Shared servers are not supported.

1 Answers  


ORA-07741: slemop: $OPEN failure

1 Answers  


ORA-03278: duplicate ALLOCATE EXTENT option specification

1 Answers  


PLS-01505: ALTER is non-ANSI

1 Answers  


ORA-03112: a server linked as single-task cannot use SQL*Net

1 Answers  






TNS-01062: The db subagent is already running.

1 Answers  


ORA-27058: file I/O question parameter is invalid

1 Answers  


LSX-00282: duplicate notation name "~S"

1 Answers  


ORA-09981: skxfqdreg: Error Adding a page to the SDI buffer pool

1 Answers  


SQL*Loader-00809: error dropping sequence: string

1 Answers  


TNS-00305: The Navigator encountered an invalid/unknown trace level

1 Answers  


DRG-12004: Password:

1 Answers  


Categories