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-23422: Oracle Server could not generate an unused job number

1 Answers  


ORA-01941: SEQUENCE keyword expected

1 Answers  


ORA-32839: property string is reserved, names with MGWPROP$_ prefix are not valid

1 Answers  


ORA-00061: another instance has a different DML_LOCKS setting

1 Answers  


ORA-01868: the leading precision of the interval is too small

1 Answers  


ORA-12806: could not get background process to hold enqueue

1 Answers  


ORA-29276: transfer timeout

1 Answers  


ORA-25110: NOSORT may not be used with a bitmap index

1 Answers  


ORA-02438: Column check constraint cannot reference other columns

1 Answers  


KUP-00601: fatal XAD error

1 Answers  


QSM-02033: no filter conditions are present in the WHERE clause

1 Answers  


TNS-00230: Cannot start new pump process: string string Protocol Adapter errors:number

1 Answers  


Categories