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

NNL-00961: Cache checkpoints: number

1 Answers  


NNO-00251: missing administrative region parameter string

1 Answers  


RMAN-06131: skip offline/readonly only allowed with current controlfile

1 Answers  


IMG-00921: threshold out of range

1 Answers  


ORA-02164: DATAFILE clause specified more than once

1 Answers  






PLS-00221: 'string' is not a procedure or is undefined

1 Answers  


ORA-00443: background process "string" did not start

1 Answers  


ORA-38951: Target platform string not cross platform compliant

1 Answers  


RMAN-04015: error setting target database character set to string

1 Answers  


ORA-03281: invalid ALLOCATE EXTENT option

1 Answers  


ORA-03280: invalid DATAFILE filename specified

1 Answers  


ORA-31459: system triggers for DBMS_CDC_PUBLISH package are not installed

1 Answers  


Categories