Oracle Database 12c New Features

ORA-14669: interval partition of reference-partitioned table must correspond to interval partition of the parent table

ORA-14669: interval partition of reference-partitioned table must correspond to interval partition of the parent table


Cause:


An attempt was made to create a reference-partitioned table with an interval partiton that does not pair with an interval partition in the parent table.



Action:


Correct the CREATE TABLE statement to specify a correct number of partitions.