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