发布时间：2014-01-30 20:47:50
闪回删除表SQL> create table emp tablespace users as select * from hr.employees;Table created.SQL> select count(*) from emp; COUNT(*)---------- 107SQL> drop table emp;Table dropped.SQL> flashback table emp to before drop;Flashback complete.SQL> s.........【阅读全文】
发布时间：2014-01-30 20:16:21
闪回表闪回hr.employees表到10分钟之前SQL> flashback table hr.employees to timestamp (systimestamp - interval '10' minute);Flashback complete.将hr.employees闪回到SCN为1080381的时候SQL> alter table hr.departments enable row movement;Table altered.将hr.employees和hr.departments两张表到SCN为108.........【阅读全文】
发布时间：2014-01-30 20:04:03
闪回表时候报错：SQL> flashback table hr.employees to timestamp (systimestamp - interval '10' minute);flashback table hr.employees to timestamp (systimestamp - interval '10' minute) *ERROR at line 1:ORA-08189: cannot flashback t.........【阅读全文】
发布时间：2014-01-30 18:24:12
闪回数据归档在USERS表空间中创建一个能够将"旧"数据保存1年的数据归档，取名"FDA1"，操作者必须拥有"flashback_archive administer"系统权限SQL> create flashback archive fda1 tablespace users retention 1 year;Flashback archive created.SQL> create flashback archive default fda_dedault tablespace use.........【阅读全文】
发布时间：2014-01-30 16:50:45
闪回版本查询SQL> select salary from hr.employees where employee_id = 200; SALARY---------- 4400SQL> update hr.employees set salary = 11111 where employee_id = 200;1 row updated.SQL> commit;Commit complete.SQL> update hr.employees set salary = 22222.........【阅读全文】
