Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: items i'll be testing first for 10g new features

RE: items i'll be testing first for 10g new features

From: Loughmiller, Greg <Greg.Loughmiller_at_cingular.com>
Date: Wed, 4 Feb 2004 12:29:49 -0500
Message-ID: <5164A49467308C45AD50661F8CFDC3430CEB70DB@s30342g004004.wdc.cingular.net>


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.



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Wed Feb 04 2004 - 11:29:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US