ORA-14652 When Using Reference Partitioning (Doc ID 1050966.1)

Last updated on MAY 12, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 22-Jul-2013***


Symptoms

CREATE TABLE ref_parent (
table_name VARCHAR2(30),
order_date DATE,
num_rows NUMBER)
PARTITION BY RANGE(num_rows) (
PARTITION num_rows1 VALUES LESS THAN (100) TABLESPACE users,
PARTITION num_rows2 VALUES LESS THAN (1000) TABLESPACE users,
PARTITION num_rows3 VALUES LESS THAN (10000) TABLESPACE users,
PARTITION num_rows4 VALUES LESS THAN (MAXVALUE) TABLESPACE users);

Table created.

 

ALTER TABLE ref_parent ADD CONSTRAINT pk_ref_parent
PRIMARY KEY (table_name) USING INDEX;

Table altered.

 

CREATE TABLE ref_child (
table_name VARCHAR2(30) ,
index_name VARCHAR2(30) ,
CONSTRAINT fk_ref_child_parent
FOREIGN KEY(table_name) REFERENCES ref_parent(table_name))
PARTITION BY REFERENCE(fk_ref_child_parent);

PARTITION BY REFERENCE(fk_ref_child_parent)
*
ERROR at line 6:
ORA-14652: reference partitioning foreign key is not supported

Cause

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 hundreds of Community platforms