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

PCB-00218: RENAMES clause not allowed for host variable "string"

1 Answers  


PLS-00254: OUT and IN/OUT modes cannot be used in this context

1 Answers  


ORA-28530: Heterogeneous Services initialization error in NLS language ID

1 Answers  


ORA-29505: AS keyword is invalid in CREATE JAVA CLASS or RESOURCE

1 Answers  


RMAN-06115: changed backup piece available

1 Answers  






TNS-01029: Services Summary...

1 Answers  


ORA-13451: GeoRaster metadata scaling function error

1 Answers  


LPX-00240: element-start tag is not well formed

1 Answers  


ORA-13249: %s

1 Answers  


ORA-06308: IPA: No more connections available

1 Answers  


ORA-13115: [string]_EDGE$ table does not exist

1 Answers  


ORA-02801: Operations timed out

1 Answers  


Categories