9I中，使用的是UNDO表空间，不支持DDL，下面是几个例子

[@more@]

i)dbms_flashback.get_system_change_number

ii)select * from t1 as of scn ...;

iii)select * from yang as of timestamp

(When enabling Flashback using a wall-clock time, the database chooses an SCN that was generated within five minutes of the time specified. )

iv)dbms_flashback.enable_at_system_change_number

select * from t1;

dbms_flashback.disable

v)dbms_flashback.enable_at_time

select * from t1;

dbms_flashback.disable

10G中：

ITPub博客

flashback的使用