Oracle9i: Recovering lost data through Flashback Query
(Doc ID 174425.1)
Last updated on NOVEMBER 11, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 9.0.1.0 to 9.0.1.0 [Release 9.0.1]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Purpose
This article introduces the new 9i Flashback feature which provides the ability to issue a query and access data as it was at some point in the past. An example
of how cursors can be used to implement the flashback feature is also presented.
Scope
This article is intended for DBAs who wish to view data at some point in the past. This is particularly useful in cases where data may has been mistakenly
deleted or updated and it is not desirable or practical to perform a point-in-time recovery to retrieve the lost data.
Details
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |