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-22321: method does not return any result

1 Answers  


NNL-00989: Objects received with no TTL: number

1 Answers  


ORA-30362: dimension column cannot be a sequence

1 Answers  


ORA-38487: FUNCTION/PACKAGE/TYPE "string" not allowed in the expression

1 Answers  


PCC-00067: Ireclen exceeded. Line number in file string truncated.

1 Answers  






DRG-10828: token string is longer than maximum length for column string

1 Answers  


ORA-01659: unable to allocate MINEXTENTS beyond string in tablespace string

1 Answers  


QSM-01572: equivalence, string, and query have different joins between tables, string

1 Answers  


ORA-29826: keyword FOR is missing

1 Answers  


ORA-16806: Supplemental logging is not turned on.

1 Answers  


ORA-01643: system tablespace can not be made read only

1 Answers  


ORA-16792: Some configurable property value is inconsistent with the database setting.

1 Answers  


Categories