PL/SQL Packages DBMS_FLASHBACK

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 



© Copyright SS64.com 1999-2014
Some rights reserved