12C 在线迁移表分区和子分区

12C支持在线迁移表分区和子分区，且同时可以进行DML操作
[code]SQL> create table pt_move_test(obj_id number,obj_name varchar2(32)) partition by range(obj_id)
2 (
3 partition pa values less than (1000),
4 partition pb values less than (10000),
5 partition pc values less than (maxvalue)
6* )
/

Table created.

SQL> insert into pt_move_test select object_id,object_name from dba_objects;

90919 rows created.

Elapsed: 00:00:02.75
SQL> commit;

SQL> select count(*) from pt_move_test partition(pa);

COUNT(*)
----------
996

Elapsed: 00:00:00.02
SQL> select count(*) from pt_move_test partition(pb);

COUNT(*)
----------
8962

Elapsed: 00:00:00.01
SQL> select count(*) from pt_move_test partition(pc);

COUNT(*)
----------
80961

Elapsed: 00:00:00.01

SQL> COL SEGMENT_NAME FOR A40
SQL> col PARTITION_NAME for a40
SQL> select SEGMENT_NAME,PARTITION_NAME,TABLESPACE_NAME from dba_segments where SEGMENT_NAME='PT_MOVE_TEST';

SEGMENT_NAME PARTITION_NAME TABLESPACE_NAME
----------------------- ----------------- ------------------
PT_MOVE_TEST PC USERS
PT_MOVE_TEST PB USERS
PT_MOVE_TEST PA USERS

SQL> alter table pt_move_test move partition pc tablespace pt_test;

Table altered.

Elapsed: 00:00:02.27[/code]

在move过程中在另外的session中可以查询

[code]SQL> select count(*) from pt_move_test;

COUNT(*)
----------
90919

SQL> select SEGMENT_NAME,PARTITION_NAME,TABLESPACE_NAME from dba_segments where SEGMENT_NAME='PT_MOVE_TEST';


SEGMENT_NAME PARTITION_NAME TABLESPACE_NAME
----------------------- ----------------- ------------------
PT_MOVE_TEST PC PT_TEST
PT_MOVE_TEST PB USERS
PT_MOVE_TEST PA USERS [/code]