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

NNC-00409: temporary name service failure

1 Answers  


ORA-01154: database busy. Open, close, mount, and dismount not allowed now

1 Answers  


PLS-00645: character set mismatch found at 'string' among operands in a COALESCE expression

1 Answers  


ORA-07643: smsalo: SMSVAR is invalid

1 Answers  


ORA-31161: element or attribute "string" cannot be stored out of line

1 Answers  






TNS-00070: INTCTL usage: [intctl] <command> <process_name> [argument]

1 Answers  


ORA-39956: duplicate setting for PL/SQL compiler parameter string

1 Answers  


AMD-00149: Custom Measure to delete "string" does not exist in Workspace "string"

1 Answers  


ORA-38734: Flashback log is inconsistent; belongs to another database.

1 Answers  


NNL-01061: Cache checkpoint interval: string

1 Answers  


DRG-11505: long data on line string not found or invalid

1 Answers  


ORA-16641: failure to acquire broker configuration metadata lock

1 Answers  


Categories