Hi Teams,
Can anyone help to track down the syntax to change the INTERVAL on a partitoned table in 11gR2.
The syntax Im using is as follows:
ORADBA@sat11cr> ALTER TABLE DATAOWNER.DS_DETAILS SET NUMTODSINTERVAL(1,'DAY'));
ALTER TABLE DATAOWNER.DS_DETAILS SET NUMTODSINTERVAL(1,'DAY'))
*
ERROR at line 1:
ORA-02000: missing UNUSED keyword
So I try to put UNUSED in:
ORADBA@sat11cr> ALTER TABLE DATAOWNER.DS_DETAILS SET UNUSED NUMTODSINTERVAL(1,'DAY'));
ALTER TABLE DATAOWNER.DS_DETAILS SET UNUSED NUMTODSINTERVAL(1,'DAY'))
*
ERROR at line 1:
ORA-00905: missing keyword
Agghhhh..
Any idea whats going on?
TABLE_NAME PARTITION PARTITION_COUNT INTERVAL
------------------------------ --------- --------------- -----------------------------------
DS_DETAILS RANGE 1048575 NUMTODSINTERVAL(7,'DAY')
ORADBA@sat11cr> desc dataowner.DS_DETAILS
Name Null? Type
----------------------------------------------------------------------------------------------------- -------- --------------------------------------------------------------------
THREAD_ID NOT NULL VARCHAR2(50)
EVENT_ID NOT NULL CHAR(36)
PROCESS_ID NOT NULL CHAR(36)
PARENT_PROCESS_ID NOT NULL CHAR(36)
LAST_ASSIGNED_STEP NUMBER(15)
FILESET VARCHAR2(100)
FILEKEY NOT NULL VARCHAR2(100)
CURRENT_STATUS CHAR(1)
COMM_DESTINATION VARCHAR2(25)
DELIVERY_EVENT VARCHAR2(25)
ILOG NUMBER(11)
INTSERVICEREF VARCHAR2(18)
PARTITION_DATE NOT NULL DATE
GGS_TS TIMESTAMP(6)
FILE_SEQ_NUM NUMBER(6)
FILE_DATA_TYPE CHAR(1)
ROUTING_REF_URL VARCHAR2(256)
TRIGGERED_NODE CHAR(1)