关于insert append

SQL> truncate table bill3g.BF_PAY_FEE_T;

Table truncated.

Elapsed: 00:00:01.22
SQL> insert /*+ append parallel(a 2) */into bill3g.BF_PAY_FEE_T a select * from bss2.BF_PAY_FEE_T@zz where city_code=890;
^Cinsert /*+ append parallel(a 2) */into bill3g.BF_PAY_FEE_T a select * from bss2.BF_PAY_FEE_T@zz where city_code=890
                                                                                                                *
ERROR at line 1:
ORA-01013: user requested cancel of current operation
ORA-02063: preceding line from ZZ
查看表空间使用量BILL3G 8,673,408

SQL> select count(*) from bill3g.BF_PAY_FEE_T
  2  /

  COUNT(*)
----------
         0

select * from dba_extents where segment_name='BF_PAY_FEE_T'；可以看出有100多个区，表的高水位没有回收，可见，insert append操作中断之后，虽然会完成高水位的回滚，但不会收缩水位，需要truncate操作来回收水位

SQL> truncate table bill3g.BF_PAY_FEE_T;

Table truncated.

select * from dba_extents where segment_name='BF_PAY_FEE_T'再次查询之后只有一个区了。

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16158219/viewspace-591789/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16158219/viewspace-591789/