SQL Language (MOSC)

MOSC Banner

Composite reference partition?

edited Feb 21, 2020 12:16PM in SQL Language (MOSC) 3 commentsAnswered

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')),

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center