ANBOB™

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推出的闪回表空间是一样的，可以参考以前的实例

打赏

微信扫一扫，打赏作者吧～