| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: items i'll be testing first for 10g new features
An analysis of reported bugs via metalink and trend that with analytical
functions provided via 10G SQL....
greg
-----Original Message-----
From: Joe Testa [mailto:oracle-l_at_oracle-dba.com]
Sent: Wednesday, February 04, 2004 9:37 AM
To: oracle-l_at_freelists.org
Subject: items i'll be testing first for 10g new features
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.
 |
 |