Oracle DBA, How To, Error, Cause and Action

ORA-04097: DDL conflict while trying to drop or alter a trigger

ORA-04097: DDL conflict while trying to drop or alter a trigger




Cause: An attempt was made to concurrently perform two DDL operations on a trigger or trigger table.




Action: Investigate the new state of the trigger and retry the DDL operation, if still appropriate.