ORA-02447: cannot defer a constraint that is not deferrable



ORA-02447: cannot defer a constraint that is not deferrable..

Answer / guest

Cause: An attempt was made to defer a nondeferrable constraint

Action: Drop the constraint and create a new one that is
deferrable

Please add more information about this Error

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-00563: password too long

1 Answers  


ORA-08196: Flashback Table operation is not allowed on AQ tables

1 Answers  


ORA-09795: szrbuild: malloc of role structure failed.

1 Answers  


TNS-12569: TNS:packet checksum failure

1 Answers  


SQL*Loader-00402: Unable to determine length of column string from specification

1 Answers  


ORA-09271: szlon: error verifying user name

1 Answers  


IMP-00093: Inconsistency between dumpfile constraint definition for table string with columns (string)

1 Answers  


ORA-23387: replication parallel push dequeue error

1 Answers  


ORA-38609: FI Not enough memory for tree counting, requires at least stringKB

1 Answers  


NID-00337: The following datafiles are read-only:

1 Answers  


ORA-27477: "string.string" already exists

1 Answers  


NZE-28787: private key encryption failure

1 Answers  


Categories