ORA-14651: reference partitioning constraint is not supported
Hi,
I have a table partitioned by LIST, and when I try to create other table with reference parttiong, it returns me:
SQL> CREATE TABLE APMETER.PAR_AGE_DIAS
2 (
3 AGE_ID NUMBER NOT NULL,
4 FECHA DATE,
5 HORAMAXDIA DATE,
6 HUECOS NUMBER,
7 CONSTRAINT ADC_AGE_FK FOREIGN KEY (AGE_ID) REFERENCES APMETER.AGE_AGENDAS (AGE_ID))
8 PARTITION BY REFERENCE(ADC_AGE_FK);
CREATE TABLE APMETER.PAR_AGE_DIAS_CITAS
*
ERROR at line 1:
ORA-14651: reference partitioning constraint is not supported
The original table has 5526 rows. If I create a original table empty and then I create the reference partitioning table again, it runs ok.
I have a table partitioned by LIST, and when I try to create other table with reference parttiong, it returns me:
SQL> CREATE TABLE APMETER.PAR_AGE_DIAS
2 (
3 AGE_ID NUMBER NOT NULL,
4 FECHA DATE,
5 HORAMAXDIA DATE,
6 HUECOS NUMBER,
7 CONSTRAINT ADC_AGE_FK FOREIGN KEY (AGE_ID) REFERENCES APMETER.AGE_AGENDAS (AGE_ID))
8 PARTITION BY REFERENCE(ADC_AGE_FK);
CREATE TABLE APMETER.PAR_AGE_DIAS_CITAS
*
ERROR at line 1:
ORA-14651: reference partitioning constraint is not supported
The original table has 5526 rows. If I create a original table empty and then I create the reference partitioning table again, it runs ok.
0