Search BC Sites

Free Oracle Tips   HTML Text

Free Oracle App Server Tips   HTML Text

Privacy Policy

Redneck

Dress Code

Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson

Easy Oracle Automation
Chapter 7 - Application and SQL Management

Flashback Transaction Query

The dba_transaction_query view stores the changes made by a transaction and the nature of changes made during a specified time. Using the transaction identifier or a time range as part of the query, this dictionary view provides information on changes made to the database by any query at any time.

When there is insufficient undo data for a transaction, the dba_transaction_query will return a row with a value of UNKNOWN in the OPERATION column.

The FLASHBACK ANY TRANSACTION system privilege is needed to issue a query against the dba_transaction_query view.

Flashback Table

The Flashback Table allows the DBA to recover database tables to a specific point in time without restoring from a backup. With this feature, the data in the tables and all associated objects including indexes, constraints, triggers etc. are restored. This statement is executed as a single transaction. All the tables must be flashed back successfully or the entire transaction is rolled back.

The Flashback Versions Query and Flashback Transaction Query can be used in tandem to determine the appropriate flashback time. The SCN should always be noted before issuing a FLASHBACK TABLE command.

For more details and scripts, see my new book " Oracle Tuning: The Definitive Reference", over 900 pages of BC's favorite tuning tips & scripts.  You can buy it direct from the publisher for 30%-off and get instant access to the code depot.