下面以11.2.0.4和12.2.0.1这两个版本为对比，观察这一新特性。
1、11.2.0.4版本的move操作
--创建测试表
zx@ORA11G>create table t as select * from dba_objects;
 
Table created.
 
Elapsed: 00:00:00.26
zx@ORA11G>insert into t select * from t;
 
79608 rows created.
 
Elapsed: 00:00:00.22
zx@ORA11G>/
 
159216 rows created.
 
Elapsed: 00:00:00.38
zx@ORA11G>/
 
318432 rows created.
 
Elapsed: 00:00:03.63
zx@ORA11G>/
 
636864 rows created.
 
Elapsed: 00:00:05.40
zx@ORA11G>/
 
1273728 rows created.
 
Elapsed: 00:00:24.57
 
zx@ORA11G>select bytes/1024/1024 from user_segments;
 
BYTES/1024/1024
---------------
        392
 
Elapsed: 00:00:00.07
zx@ORA11G>commit;
 
Commit complete.
 
Elapsed: 00:00:00.01
zx@ORA11G>alter system flush buffer_cache;
 
System altered.
 
Elapsed: 00:00:27.90
--不做move操作时delete操作时间
zx@ORA11G>delete from t where object_name='T';
 
32 rows deleted.
 
Elapsed: 00:00:00.13
zx@ORA11G>rollback;
 
Rollback complete.
--执行move
--session 1
zx@ORA11G>select userenv('sid') from dual;
 
USERENV('SID')
--------------
      1150
--session 2 
zx@ORA11G>select userenv('sid') from dual;
 
USERENV('SID')
--------------
        15
--session 1
zx@ORA11G>alter table t move tablespace examples;
 
Table altered.
 
Elapsed: 00:00:02.45
--session 2
zx@ORA11G>delete from t where object_name='T';
 
32 rows deleted.
 
Elapsed: 00:00:02.18
zx@ORA11G>rollback;
 
Rollback complete.
--session 3
sys@ORA11G>select /*+ rule */ sid,lmode,request,type,block from v$lock where sid in (1150,15);
 
      SID  LMODE    REQUEST TY    BLOCK
---------- ---------- ---------- -- ----------
      1150        6          0 TM      1
      1150        4          0 AE      0
      1150        6          0 TS      0
      1150        6          0 TX      0
      1150        2          0 XR      0
    15      4          0 AE      0
    15      0          3 TM      0
 
7 rows selected