ALL,
I am trying to create partition on the a column which is defined as
TIMESTAMP(6) WITH TIME ZONE DEFAULT SYSTIMESTAMP AT TIME ZONE 'US/CENTRAL'
NOT NULL ENABLE
but getting error
Error report -
ORA-03001: unimplemented feature
03001. 00000 - "unimplemented feature"
*Cause: This feature is not implemented.
*Action: None.
below is the DDL
CREATE TABLE TAB_PIT (
DATA_ID NUMBER(10,0)
NOT NULL ENABLE,
CREATED_DT TIMESTAMP(6) WITH TIME ZONE DEFAULT SYSTIMESTAMP AT TIME ZONE 'US/CENTRAL'
NOT NULL ENABLE,
CREATED_BY VARCHAR2(20 BYTE),
MODIFIED_DT TIMESTAMP(6) WITH TIME ZONE DEFAULT SYSTIMESTAMP AT TIME ZONE 'US/CENTRAL'
NOT NULL ENABLE
)
PARTITION BY RANGE ( CREATED_DT ) INTERVAL ( NUMTOYMINTERVAL(1,'MONTH') ) ( PARTITION P0
VALUES LESS THAN ( TO_DATE('01-JAN-2006','DD-MON-YYYY') )
);
Can anybody help me with this issue. I have seen examples where column with LOCAL TIME ZONE have been partitioned.