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

IMG-00545: invalid cut values specified

1 Answers  


TNS-00281: Connection Manager: Forced Log output

1 Answers  


RMAN-06070: DBWR could not identify datafile string

1 Answers  


ORA-19638: file string is not current enough to apply this incremental backup

1 Answers  


DRG-50916: last document string is less than first document

1 Answers  






DGM-16960: status not available

1 Answers  


ORA-13187: subdivision failed

1 Answers  


ORA-37016: (XSACQUIRE01) You must specify objects to acquire for the ACQUIRE command.

1 Answers  


ORA-12477: greatest lower bound resulted in an invalid OS label

1 Answers  


NNL-00239: Resetting of statistic counters is now disabled

1 Answers  


RMAN-08097: channel string: starting validation of archive log backupset

1 Answers  


RMAN-08503: piece handle=string comment=string

1 Answers  


Categories