Flash back to a version of the database at a specific time or a specific System Change Number (SCN)
Subprocedures:
ENABLE_AT_TIME This procedure enables Flashback for the entire session.
The snapshot time is set to the SCN that most closely
matches the time specified in query_time.
ENABLE_AT_SYSTEM_CHANGE_NUMBER
Takes an SCN as an Oracle number and sets the session
snapshot to the specified number.
Inside the Flashback mode, all queries will return data
consistent as of the specified wall-clock time or SCN.
GET_SYSTEM_CHANGE_NUMBER Function
Returns the current SCN as an Oracle number.
You can use the SCN to store specific snapshots.
DISABLE Disables the Flashback mode for the entire session.
For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"
or the book Oracle Built in Packages by Steven Feuerstein et al
"Knife the baby" - Christopher Phillips, Microsoft Executive
Related Commands:
ROLLBACK
Related Views:
V$TRANSACTION V$TRANSACTION_ENQUEUE V$GLOBAL_TRANSACTION