Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-08118: Deferred FK constraints cannot be enforced, index
too big (string)



ORA-08118: Deferred FK constraints cannot be enforced, index too big (string)..

Answer / guest

Cause: Deferred Foreign Key constraints cannot be enforced
due to the index key being too big and built on a
non-default DB_BLOCK_SIZE.

Action: First try to drop the Foreign Key and then the
primary key.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNO-00605: enabling modification requests

1 Answers  


QSM-01125: a more optimal set operator materialized view than string was used to rewrite

1 Answers  


PCC-02043: CMD-LINE: Option syntax is incorrect

1 Answers  


ORA-13632: The user cancelled the current operation.

1 Answers  


ORA-22064: invalid NLS parameter string [string]

1 Answers  






TNS-12687: Credentials expired.

1 Answers  


ORA-16212: number processes specified for APPLY is too great

1 Answers  


PLS-00425: in SQL, function argument and return types must be SQL type

1 Answers  


ORA-23608: invalid resolution column "string"

1 Answers  


ORA-02875: smpini: Unable to get shared memory for PGA

1 Answers  


ORA-39129: Object type string not imported. Name conflicts with the master table

1 Answers  


PROC-00009: Cannot perform cluster registry operation because the buffer passed is too small.

1 Answers  






Categories