Use the SET SUBPARTITION TEMPLATE clause, like this:
ALTER TABLE SCOTT.MYTABLE SET SUBPARTITION TEMPLATE (SUBPARTITION SP_2014 VALUES ('2014') TABLESPACE USERS, SUBPARTITION SP_2015 VALUES ('2015') TABLESPACE USERS, SUBPARTITION SP_2016 VALUES ('2016') TABLESPACE USERS, SUBPARTITION SP_2017 VALUES ('2017') TABLESPACE USERS, SUBPARTITION SP_2018 VALUES ('2018') TABLESPACE USERS, SUBPARTITION SP_2019 VALUES ('2019') TABLESPACE USERS, SUBPARTITION SP_2020 VALUES ('2020') TABLESPACE USERS, SUBPARTITION SP_DEFAULT VALUES (default) TABLESPACE USERS );
Source: Oracle Documentation
No comments:
Post a Comment