首页 » ORACLE » flashback DDL not affect

flashback DDL not affect

SQL> conn anbob/anbob
Connected.
SQL> create table testfls(id int);

Table created.

SQL> set time on

23:07:42 SQL> insert into testfls values(1);

1 row created.

23:07:49 SQL> commit;

Commit complete.

23:07:52 SQL> delete testfls;

1 row deleted.

23:08:20 SQL> commit;

Commit complete.

23:08:56 SQL> select * from testfls as of timestamp sysdate-1/24/60
23:09:03 2 ;

ID
———-
1

23:09:04 SQL> select * from testfls as of timestamp sysdate-1/24/60
23:09:27 2 ;

no rows selected

23:09:29 SQL> alter table testfls add name varchar2(10);

Table altered.

23:09:56 SQL> select * from testfls as of timestamp sysdate-1/24/60
23:10:00 2 ;

no rows selected

23:10:01 SQL> select * from testfls as of timestamp sysdate-2/24/60
23:10:06 2 ;

ID NAME
———- ———-
1

flashback query 可以闪回以前的数据行,但不可以闪回alter table修改前的表结构,这点在11G推出的闪回表空间是一样的,可以参考以前的实例

打赏

目前这篇文章有1条评论(Rss)评论关闭。

  1. Haywood Pesterfield | #1
    2011-12-21 at 04:12

    It sounds like you’re generating troubles yourself by wanting to solve this concern as a substitute of looking at why their is often a problem in the first place