My Oracle Support Banner

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

Last updated on NOVEMBER 06, 2023

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!

In this Document
Symptoms
Cause
Solution
References


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