2个的区别是什么？

显示全部楼层 · 2007-9-26 18:42:10

alter table prod shrink space
和
alter table prod shrink space compact
的区别？

千问 · 2007-9-26 18:42:10

http://air09.itpub.net/post/25702/304497
http://air09.itpub.net/post/25702/304499

千问 · 2007-9-26 18:42:10

SQL> insert into t3 select * from t3;
已创建7680行。
SQL> commit;
提交完成。
SQL> select blocks from user_segments where segment_name = 'T3';
BLOCKS
----------
32
SQL> delete from t3 where mod(page,10) delete from t3 where mod(page,10) commit;
提交完成。
SQL> select blocks from user_segments where segment_name = 'T3';
BLOCKS
----------
32
SQL> alter table t3 shrink space compact;
表已更改。
SQL> select blocks from user_segments where segment_name = 'T3';
BLOCKS
----------
32
SQL> alter table t3 shrink space;
表已更改。
SQL> select blocks from user_segments where segment_name = 'T3';
BLOCKS
----------
16
SQL>