items i'll be testing first for 10g new features
- From: Joe Testa <oracle-l@xxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 04 Feb 2004 09:37:18 -0500
Oracle Flashback Database
This feature introduces the |FLASHBACK| |DATABASE| statement in SQL. It
let you quickly bring your database to a prior point in time by undoing
all the changes that have taken place since that time. This operation is
fast, because you do not need to restore the backups. This in turn
results in much less downtime following data corruption or human error.
Oracle Flashback Table
This feature introduces the |FLASHBACK| |TABLE| statement in SQL, which
enables you to quickly recover a table to a point in time in the past
without restoring a backup.
Oracle Flashback Version Query
Using undo data stored in the database, you can now view the changes to
one or more rows along with all the metadata of the changes.
Oracle Flashback Drop
Oracle now provides a way to restore accidentally dropped tables.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
