ITPub博客

首页 > 数据库 > Oracle > Oracle 9I FlashBack 测试

Oracle 9I FlashBack 测试

原创 Oracle 作者:ysjxjf 时间:2006-07-05 14:33:25 0 删除 编辑
Oracle 9I FlashBack 测试[@more@]
15:08:22 SQL> execute DBMS_flashback.ENABLE_AT_TIME(to_date('2003-05-16 15:00:00'));

PL/SQL procedure successfully completed.

15:09:02 SQL> select * from t;

A

----------

gototop

www.ncn.cn

www.ncn.cn

15:16:43 SQL> execute DBMS_flashback.DISABLE;

PL/SQL procedure successfully completed.
-----------------------------------------------------------------------
15:38:57 SQL> declare

15:39:28 2 cursor flash_recover is

15:39:28 3 select * from t;

15:39:28 4 t_recode t%rowtype;

15:39:28 5 begin

15:39:28 6 DBMS_flashback.ENABLE_AT_TIME(to_date('2003-05-16 15:37:23'));

15:39:28 7 open FLASH_RECOVER;

15:39:28 8 DBMS_flashback.DISABLE;

15:39:28 9 loop

15:39:28 10 FETCH FLASH_RECOVER INTO t_recode;

15:39:28 11 EXIT WHEN FLASH_RECOVER%NOTFOUND;

15:39:28 12 insert into t values (t_recode.a);

15:39:28 13 end loop;

15:39:28 14 CLOSE FLASH_RECOVER;

15:39:28 15 commit;

15:39:28 16 end;

15:39:28 17 /

PL/SQL procedure successfully completed.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/66634/viewspace-847214/,如需转载,请注明出处,否则将追究法律责任。

上一篇: Linux 使用
请登录后发表评论 登录
全部评论

注册时间:2008-04-24

  • 博文量
    380
  • 访问量
    3210562