SPLIT PARTITIONING SUB PARTITIONS
Hi All,
I have requirement to split sub partition on table with 160 million rows, attached metadata of it ,. please let me know how to do a split partitions without any impact of data, indexes etc,
i need to split the existing DEFAULT sub partition into two partitions For EG : QGBLI, DEFAULT.
ALTER TABLE TEST ADD PARTITION YR16_P1 VALUES LESS THAN (2016, 2)
NOLOGGING
NOCOMPRESS
TABLESPACE TEST
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
( SUBPARTITION YR16_P1_QUGBL VALUES ('QUGBL') TABLESPACE TEST,
SUBPARTITION YR16_P1_INNUK VALUES ('INNUK') TABLESPACE TEST,
SUBPARTITION YR16_P1_QUEUR VALUES ('QUEUR') TABLESPACE TEST,
SUBPARTITION YR16_P1_INNSS VALUES ('INNSS') TABLESPACE TEST,