Database DataWarehousing (MOSC)

MOSC Banner

subpartition list Oracle 12.2.0.1

edited Apr 11, 2018 10:48PM in Database DataWarehousing (MOSC) 6 commentsAnswered

Hello,

I would like to use automatic list partition but it seems it does not work for subpartition list.

is my syntax correct?

Thanks for your help

CREATE orders (

   order_id NUMBER (12),

   order_date DATE CONSTRAINT order_date_nn NOT NULL,

   state VARCHAR2(2),

   flag CHAR(1),

   ind CHAR(1)

   )

     PARTITION BY RANGE (order_date) INTERVAL(NUMTOYMINTERVAL(1, 'MONTH'))

     SUBPARTITION BY LIST (state,flag, ind) AUTOMATIC

  SUBPARTITION TEMPLATE

     ( SUBPARTITION order_d1 VALUES ('AA', 'Y', '1'),

       SUBPARTITION order_d2 VALUES (('BB', 'N','3'),('CC', 'Y','3')))

     (PARTITION order_p1 VALUES LESS THAN (TO_DATE ('01-DEC-2015','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