Oracle 10g New Features

RECOVERABILITY/SECURITY

Flashback


Flashback Database
Flashes back changes to entire database

- Powerful feature to help in resolution of user errors that cause
changes to database

- Much faster method of recovering data than other methods
(tablespace point in time recovery, logical backups, or log miner)


Flashback Drop
-Allow you to undo the effects of a drop table

-Concept of a recycle bin

Flashback Versions Query
-Allows you to see all versions of data for a given row over a period of time



Flashback Transaction

-Reconstructs the SQL statements that have been previously executed in the database