Forum Stats

  • 3,768,003 Users
  • 2,252,739 Discussions
  • 7,874,406 Comments

Discussions

hybrid partition support sub partition?

supersen
supersen Member Posts: 426 Blue Ribbon
edited Aug 6, 2021 5:38AM in Database 19c-21c

i have requirment to move old data into flat file or outside db

already the table is partitioned based on key id and management wants move old data into partition data before year 2010 to oracle external loader datapump using hybrid partition

i tried

CREATE TABLE "FAQ"."FAC"

   ( "key_id " NUMBER NOT NULL ENABLE,

"ID" NUMBER NOT NULL ENABLE,

"REVISION_NUM" NUMBER NOT NULL ENABLE,

"DISCHARGEDATE" TIMESTAMP (6),

"STATUS" NUMBER DEFAULT 1 NOT NULL ENABLE,

"FILTERDATE" TIMESTAMP (6)

   )

  PARTITION BY RANGE(key_id )

INTERVAL (1)

SUBPARTITION BY RANGE(FILTERDATE)

SUBPARTITION TEMPLATE

( SUBPARTITION filter_dt_2010 VALUES LESS THAN (TIMESTAMP '2010-01-01 00:00:00.000000')

, SUBPARTITION filterdt_gt VALUES LESS THAN (MAXVALUE)

)

(PARTITION "KEY_BAD" VALUES LESS THAN (0) );


ORA-14354 OPERATION NOT SUPPORTED FOR hybrid partition

why i am getting this error? hybrid partition does not support subpartition?


Please answer