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

KUP-04064: fatal error during initialization

1 Answers  


DRG-10851: Invalid grammar string specified for query template

1 Answers  


ORA-31520: CDC subscription string already subscribes to publication ID string

1 Answers  


RMAN-06571: datafile number does not have recoverable copy

1 Answers  


RMAN-06464: BACKUP BACKUPSET is not supported with VALIDATE option

1 Answers  






ORA-30189: reserved for future use

1 Answers  


ORA-14029: GLOBAL partitioned index must be prefixed

1 Answers  


ORA-12159: TNS:trace file not writeable

1 Answers  


ORA-14193: invalid ALTER INDEX MODIFY SUBPARTITION option

1 Answers  


ORA-10646: Too many recursive extensions during SYSTEM tablespace migration

1 Answers  


ORA-26097: unsupported conversion for column string (from type number to type number)

1 Answers  


ORA-19030: Method invalid for non-schema based XML Documents.

1 Answers  


Categories