ORA-12001: cannot create log: table 'string' already has a
trigger



ORA-12001: cannot create log: table 'string' already has a trigger..

Answer / guest

Cause: Materialized view logs are filled by a trigger on the
master table. That trigger cannot be created.

Action: To create a materialized view log, drop the current
trigger on the master.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02158: invalid CREATE INDEX option

1 Answers  


ORA-13343: a polygon geometry has fewer than four coordinates

1 Answers  


SQL-02131: Runtime context in use

2 Answers  


IMP-00004: invalid username or password

1 Answers  


TNS-12560: TNS:protocol adapter error

1 Answers  






ORA-16131: An error occurred during a Terminal Recovery of the standby.

1 Answers  


ORA-12040: master rollback segment option not support by master site string

1 Answers  


ORA-07490: scgrcl: cannot convert lock.

1 Answers  


ORA-02303: cannot drop or replace a type with type or table dependents

1 Answers  


ORA-31429: subscription has not been activated

1 Answers  


ORA-29848: error occurred in the execution of ODCIINDEXMERGEPARTITION routine

1 Answers  


ORA-01734: illegal parameters - EXTENT MIN higher than EXTENT MAX

1 Answers  


Categories