SQL> CREATE TABLE TRANSACTION_DETAILS
(TRAN_DTL_ID NUMBER,
DETAIL VARCHAR2(100),
CONSTRAINT TRAN_DTL_FK
FOREIGN KEY(TRAN_DTL_ID) 
REFERENCES TRANSACTIONS_MAIN(TRAN_ID))
PARTITION BY REFERENCE(TRAN_DTL_FK)  2    3    4    5    6    7  ;
PARTITION BY REFERENCE(TRAN_DTL_FK)
                       *
ERROR at line 7:
ORA-14652: reference partitioning foreign key is not supported

Note : while creating reference partitioning table , foreign key must be not null

SQL> 
CREATE TABLE TRANSACTION_DETAILS
(TRAN_DTL_ID NUMBER NOT NULL,
DETAIL VARCHAR2(100),
CONSTRAINT TRAN_DTL_FK
FOREIGN KEY(TRAN_DTL_ID) 
REFERENCES TRANSACTIONS_MAIN(TRAN_ID))
PARTITION BY REFERENCE(TRAN_DTL_FK)SQL>   2    3    4    5    6    7  ;

Table created.
Tagged:

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.