oracle 高水位线问题

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

--查询高水位线 502950 281850
select blocks, empty_blocks from dba_tables where table_name='TODAYOTHERCONSUMERECORDS' and owner='ICCARDYIWU'
----
alter table TODAYOTHERCONSUMERECORDS enable row movement;
---
alter table TODAYOTHERCONSUMERECORDS shrink space;

select table_name,BLOCKS,EMPTY_BLOCKS,NUM_ROWS from user_tables where table_name = upper('TODAYOTHERCONSUMERECORDS');

能 truncate 最好 truncate

如果不能就加上
alter table TODAYOTHERCONSUMERECORDS enable row movement;
---
alter table TODAYOTHERCONSUMERECORDS shrink space;

这个会修改表数据存储的数据块位置重新分配，加到 delete 后面就可以

就是一个表的数据误删掉可以用闪回找回来

如果执行这个就不能闪回

alter table XXX enable row movement;
alter table XXX shrink space;

select blocks, empty_blocks from dba_tables where table_name='ARCHIVEDCONSUMERECORDS_201712'
and owner='ICCARDUSER';

alter table ARCHIVEDCONSUMERECORDS_201712 enable row movement;
alter table ARCHIVEDCONSUMERECORDS_201712 shrink space;

select * from ARCHIVEDCONSUMERECORDS_201712