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

AMD-00111: PROCEDURE string, invalid directory: "string"

1 Answers  


ORA-02800: Requests timed out

1 Answers  


NNO-00056: warning: domain minimum TTL must be between number and number, set to number seconds

1 Answers  


RMAN-06106: this command requires that target database be mounted

1 Answers  


ORA-22909: exceeded maximum VARRAY limit

1 Answers  


RMAN-06745: skipping datafilecopy string; already backed up string time(s)

1 Answers  


NZE-28780: invalid data access method specified by the parameter

1 Answers  


ORA-23293: Cannot rename a column which is part of a join index

1 Answers  


ORA-00972: identifier is too long

1 Answers  


RMAN-06532: redundancy count must be greater than zero

1 Answers  


ORA-15182: ASMLIB [string] version mismatch, oracle version [string]

1 Answers  


ORA-06700: TLI Driver: incorrect message type from host

1 Answers  


Categories