Wednesday 15 February 2012

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

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

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.

No comments:

Post a Comment