All Oracle Error CodesOracle DBA Forum

ORA-02447:

cannot defer a constraint that is not deferrable
Cause: An attempt was made to defer a nondeferrable constraint
Action: Drop the constraint and create a new one that is deferrable