已经2Old 了，记录在此做个备查。

第一步：调整数据库

alter system set log_archive_dest ='D:\app\Administrator\oradata\orcl\archive' scope=spfile;

alter system set db_recovery_file_dest ='E:\archive' scope=spfile;

alter system set db_recovery_file_dest_size =4G scope=spfile;

shutdown immediate

startup mount

alter database archivelog;

alter database flashback on;

alter database open;

第二步：调整表

ALTER TABLE plan

ENABLE ROW MOVEMENT;

select count(*) from plan ;

delete from plan;

commit;

FLASHBACK TABLE plan

TO TIMESTAMP (SYSTIMESTAMP - INTERVAL '1' minute);

select count(*) from plan ;