ORACLE闪来技术

ORACLE闪回技术

1 .误删了一部分数据 (delete) 想回恢复数据，oracle flashback闪回误删除的表数据

SQL> alter table ps_audit_groupactivity enable row movement;
SQL> flashback table ps_audit_groupactivity to timestamp to_timestamp('2007-04-30 10:00:00','yyyy-mm-dd hh24:mi:ss');


2. 删除表后 需要恢复该表
SQL>? select *from recyclebin where type='TABLE' and original_name='TABLE_NAME';
SQL> flashback table test_drop to before drop;或
SQL> flashback table "BIN$b+XkkO1RS5K10uKo9BfmuA==$0" to before drop;