My Oracle Support Banner

ORA-2266 when Dropping Parent Partition of a Reference Partitioned Table (Doc ID 2008493.1)

Last updated on MAY 13, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

 You try to drop a partiton from the parent table of a partition-referenced child table and get an ORA-2266: unique/primary keys in table referenced by enabled foreign keys.    The partition drop is successful if the partition is empty.

 

Note: Under the partitioning conditions described in this note, you could also receive an ORA-14099: all rows in table do not qualify for specified partition when doing exchange partition on the parent table.

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.