使用DBMS_REDEFINITION在线重定义分区表(二)
--------- ------- ---------------
TAB_UNPART TABLE COL2 RANGE VALID TAB_PART_2013
TAB_UNPART TABLE COL2 RANGE VALID TAB_PART_2011
TAB_UNPART TABLE COL2 RANGE VALID TAB_PART_2012
SQL> SELECT * FROM tab_unpart partition (TAB_PART_2012);
COL COL2
--- ------------
-1 05-JAN-11
SQL> SELECT * FROM tab_unpart partition (TAB_PART_2011);
no ROWS selected
SQL> SELECT * FROM tab_unpart partition (TAB_PART_2013);
COL COL2
--- ------------
0 05-JAN-12
1 30-DEC-12