Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-04097 – DDL conflict while trying to drop or alter a trigger

Oracle Database Error Code ORA-4097 Description :

DDL conflict while trying to drop or alter a trigger

Error Cause:

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

How to Solve :

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