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-19694: some changed blocks were not found in the change tracking file

1 Answers  


PLS-00609: the OVERRIDING clause is not valid for SQLJ Object Types

1 Answers  


ORA-12003: materialized view "string"."string" does not exist

1 Answers  


ORA-09884: Two Task interface: SID doens't match current PU

1 Answers  


ORA-14621: cannot add subpartition when DEFAULT subpartition exists

1 Answers  






NNL-01005: UNKNOWN TYPE responses received: number

1 Answers  


PCC-02384: Missing array length specifier

1 Answers  


ORA-00051: timeout occurred while waiting for a resource

1 Answers  


RMAN-04006: error from auxiliary database: string

1 Answers  


ORA-04054: database link string does not exist

1 Answers  


SQL*Loader-00911: Error defining output variable(s) for upi: [number]

1 Answers  


ORA-08120: Need to create SYS.IND_ONLINE$ table in order to (re)build index

1 Answers  


Categories