Oracle DBA, How To, Error, Cause and Action

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.