12C 在线move datafile

12C中移动数据文件不需要将datafile离线，且在move过程中支持DML操作，下面是测试实例：
[code]SQL> select a.name,b.name from v$datafile a , v$tablespace b where a.ts#=b.ts#;

NAME NAME
------------------------------------------------------------ ------------------------------------------------------------
/oracle/12c/oradata/orcl12c/users01.dbf USERS
/oracle/12c/oradata/orcl12c/undotbs01.dbf TEMP
/oracle/12c/oradata/orcl12c/undotbs01.dbf UNDOTBS1
/oracle/12c/oradata/orcl12c/undotbs01.dbf TEMP
/oracle/12c/oradata/orcl12c/system01.dbf SYSTEM
/oracle/12c/oradata/orcl12c/sysaux01.dbf SYSAUX
......


SQL> select TABLE_NAME,TABLESPACE_NAME from dba_tables where TABLE_NAME='N_OBJ';

TABLE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME
------------------------------
N_OBJ
USERS

SQL> desc c##awen.n_obj;
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER VARCHAR2(128)
OBJECT_NAME VARCHAR2(128)
SUBOBJECT_NAME VARCHAR2(128)
OBJECT_ID NUMBER
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR2(23)
CREATED DATE
LAST_DDL_TIME DATE
TIMESTAMP VARCHAR2(19)
STATUS VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
NAMESPACE NUMBER
EDITION_NAME VARCHAR2(128)
SHARING VARCHAR2(13)
EDITIONABLE VARCHAR2(1)
ORACLE_MAINTAINED VARCHAR2(1)

SQL> select count(*) from c##awen.N_OBJ;

COUNT(*)
----------
1000

这时候开一个session move表空间，且同时执行下面的过程
SQL> begin
2 for i in 1004 .. 10000
3 loop
4 insert into c##awen.N_OBJ(object_id,object_name) values (i,'awen');
5 commit;
6 end loop;
7* end;
/

PL/SQL procedure successfully completed.

[oracle@ora12c ~]$ sqlplus / as sysdba

SQL> alter database move datafile '/oracle/12c/oradata/orcl12c/users01.dbf' to '/oracle/12c/oradata/orcl12c/users_01.dbf';

Database altered.


SQL> select count(*) from c##awen.N_OBJ;

COUNT(*)
----------
9997


SQL> select a.name,b.name from v$datafile a , v$tablespace b where a.ts#=b.ts#;

NAME NAME
------------------------------------------------------------ ------------------------------------------------------------
/oracle/12c/oradata/orcl12c/users_01.dbf USERS[/code]