oracle数据库回收站

---查看oracle回收站是否开启

select value from V$parameter where name = 'recyclebin';

---开启关闭回收站功能

SQL> alter system set recyclebin = on scope=spfile;

SQL> alter session set recyclebin = on scope=spfile;

---关闭

SQL> alter system set recyclebin = off scope=spfile;

SQL> alter session set recyclebin = off scope=spfile;

---查看回收站内容

select * from user_recyclebin t where t.original_name='lh_batch_info';

---恢复被删除的表

flashback table lh_batch_info to before drop;

---恢复删除时重命名

flashback table lh_batch_info to before drop rename to lh_batch_info_n;

---开启行移动功能

alter table 表名 enable row movement;

---恢复表数据

flashback table 表名 to timestamp to_timestamp('2014-05-19 09:40:00','yyyy-mm-dd hh24:mi:ss');

---上述时间为删除数据的时间

---备注：恢复后请关闭行移动功能