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