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

ORA-01143: cannot disable media recovery - file string needs media recovery

1 Answers  


ORA-04017: invalid value string (length = string) for parameter max_dump_file_size

1 Answers  


ORA-22319: type attribute information altered in ALTER TYPE

1 Answers  


NCR-04010: NCRR: Unable to contact Oracle Names Server

1 Answers  


ORA-31439: subscription is already active

1 Answers  






ORA-16529: bad sender id

1 Answers  


TNS-04044: Specified gateways do not exist.

1 Answers  


NNO-00084: domain "string" is not in the authoritative domain list

1 Answers  


ORA-06703: TLI Driver: send break message failed

1 Answers  


ORA-07246: sfofi: open error, unable to open database file.

1 Answers  


ORA-28233: double encryption not supported

1 Answers  


NNO-00617: enabling AUTHORITY-REQUIRED on system queries

1 Answers  


Categories