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

ORA-14518: partition contains rows corresponding to values being dropped

1 Answers  


ORA-30194: reserved for future use

1 Answers  


ORA-28105: cannot create security relevant column policy in an object view

1 Answers  


ORA-12418: user string not found

1 Answers  


ORA-09310: sclgt: error freeing latch

1 Answers  


ORA-30044: 'Retention' can only specified for undo tablespace

1 Answers  


ORA-28168: attempted to grant password-protected role

1 Answers  


ORA-39314: illegal sync_code() call: only applys after clone/sync_code

1 Answers  


ORA-16095: Dependent destination removal for inactivation

1 Answers  


PLS-00537: A VARRAY must have a positive limit

1 Answers  


IMG-00800: internal error while parsing attribute string

1 Answers  


RMAN-20034: resync not needed

1 Answers  


Categories