Is it possible to change the SUBPARTITION TEMPLATE of the table which has got the data.
I want to add one more value
to the subpartiion template.
SUBPARTITION TEMPLATE
(SUBPARTITION PRD VALUES ('303', '660', '148', '150') TABLESPACE TEST,
SUBPARTITION PRD1 VALUES ('238', '76') TABLESPACE TEST,
)
complete Table script .
CREATE TABLE SYSADM.TEST1
(
BUSINESS_UNIT VARCHAR2(5 BYTE) NOT NULL,
FI_INSTRUMENT_ID VARCHAR2(20 BYTE) NOT NULL,
FI_IBALTYPE_CD VARCHAR2(10 BYTE) NOT NULL,
ASOF_DT DATE,
ASOF_STATUS VARCHAR2(2 BYTE) NOT NULL,
FI_BALANCE_AMT NUMBER(18,3) NOT NULL,
FI_BALANCE_BCE_AMT NUMBER(18,3) NOT NULL,
FI_ACCRINT_AMT NUMBER(18,3) NOT NULL,
FI_ACCRINT_BCE_AMT NUMBER(18,3) NOT NULL,T
CURRENCY_CD VARCHAR2(3 BYTE) NOT NULL,
BASE_CURRENCY VARCHAR2(3 BYTE) NOT NULL,
FI_LST_PAYMNT_DT DATE,
PROCESS_INSTANCE NUMBER(10) NOT NULL
)
TABLESPACE TEST
LOGGING
PARTITION BY RANGE (AS_DT)
SUBPARTITION BY LIST (BUSINESS_UNIT)
SUBPARTITION TEMPLATE
(SUBPARTITION PRD VALUES ('303', '660', '148', '150') TABLESPACE TEST,
SUBPARTITION PRD1 VALUES ('238', '76') TABLESPACE TEST,
)
(
PARTITION JUN_2011 VALUES LESS THAN (TO_DATE(' 2011-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
NOLOGGING
NOCOMPRESS
TABLESPACE TEST
( SUBPARTITION JUN_2011_PRD VALUES ('303', '660', '148', '150') TABLESPACE TEST,
SUBPARTITION JUN_2011_PRD1 VALUES ('238', '76') TABLESPACE TEST
),
PARTITION JULY_2011 VALUES LESS THAN (TO_DATE(' 2011-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
NOLOGGING
NOCOMPRESS
TABLESPACE TEST
( SUBPARTITION JULY_2011_PRD VALUES ('303', '660', '148', '150') TABLESPACE TEST,
SUBPARTITION JULY_2011_PRD1 VALUES ('238', '76') TABLESPACE TEST,
)
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;