查看表的大小;
select a.blocks,a.bytes,a.bytes/1024/1024 from user_segments a
where a.segment_name='B_M_DZYH_CUST_SIGN_FACT';
首先
create table TEST_1228 as select * from user_tables;
insert into TEST_1228 select * from TEST_1228 ;
insert into TEST_1228 select * from TEST_1228 ;
insert into TEST_1228 select * from TEST_1228 ;
insert into TEST_1228 select * from TEST_1228 ;
insert into TEST_1228 select * from TEST_1228 ;
commit;
查看表的空间大小:记录为1
select a.blocks,a.bytes,a.bytes/1024/1024 from dba_segments a
where a.segment_name='TEST_1228'
删除表
delete from TEST_1228 ;
commit;
查看表的空间大小:记录为2
select a.blocks,a.bytes,a.bytes/1024/1024 from dba_segments a
where a.segment_name='TEST_1228'
移动高水位:
alter table TEST_1228 enable row movement
alter table TEST_1228 shrink space
查看表的空间大小:记录为3
select a.blocks,a.bytes,a.bytes/1024/1024 from dba_segments a
where a.segment_name='TEST_1228'
对比1,2,3结果,即可