Composite reference partition?
Is it possible in Oracle 12.1 to create a reference partition from a composite partitioned table?
For example if I have the following tables:
CID (parent table)
CID_ID NUMBER(20,0),
SPID NUMBER(20,0),
CREATED_DTM TIMESTAMP,
CIDES (child table)
CIDES_ID NUMBER(20,0),
CID_ID NUMBER(20,0),
SPID NUMBER(20,0),
CREATED_DTM TIMESTAMP,
If my CID table is composite partitioned by LIST (SPID) and then subpartitioned by RANGE (CREATED_DTM) as follows:
PARTITION BY LIST (SPID)
SUBPARTITION BY RANGE (CREATED_DTM)
(PARTITION CIS_9009 VALUES VALUES (9009),
(
SUBPARTITION CIS_9009_JAN_18_2020 LESS THAN (TO_DATE('19-JAN-2020','DD-MON-YYYY')),
SUBPARTITION CIS_9009_JAN_19_2020 LESS THAN (TO_DATE('20-JAN-2020','DD-MON-YYYY')),