ALTER TABLE SCOTT.EMPLOYEES
SPLIT PARTITION START_DATE_MAX AT (TO_DATE('2014-03-01', 'YYYY-MM-DD'))
INTO (
PARTITION START_DATE_FEB_2014 TABLESPACE ACTIVE_DATA,
PARTITION START_DATE_MAX TABLESPACE TOOLS
);
For a list-partitioned table:
ALTER TABLE received_documents
SPLIT PARTITION OTHERS
VALUES ('EAST','WEST','NORTH','SOUTH')
INTO (PARTITION NON_EU_CITIZEN,
PARTITION OTHERS
) UPDATE INDEXES PARALLEL 8;
See this post for an example of splitting a default subpartition.
No comments:
Post a Comment