How to Split a Partition on a Range-Partitioned Table?
Do I add the partition this way:
ALTER TABLE SALES_BUSINESS_AREA
ADD PARTITION SALES_08 LESS THAN ('2009')
TABLESPACE OLAPTS_2008;
ALTER TABLE SALES_BUSINESS_AREA
ADD PARTITION SALES_09 LESS THAN (MAXVALUE)
TABLESPACE OLAPTS_2009;
Or do I split the partition (I don’t know what to do here):
ALTER TABLE SALES_BUSINESS_AREA SPLIT PARTITION SALES_07
AT (2008)
INTO ( PARTITION SALES_07 TABLESPACE OLAPTS_2007,
PARTITION SALES_08 TABLESPACE OLAPTS_2008,
???????
Table:
CREATE TABLE SALES_BUSINESS_AREA
(
...
)
TABLESPACE OLAPTS
PCTUSED 0
PCTFREE 20
INITRANS 1
MAXTRANS 255
STORAGE (
BUFFER_POOL KEEP
)
NOLOGGING
PARTITION BY RANGE (YEAR) |