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.

No comments:

Post a Comment

Thanks for your comment.