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

Oracle Error Message

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

Reason for the Error

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

Solution

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