In Oracle database

Oracle database

The Oracle Database is an object-relational database management system produced and marketed by Oracle Corporation....

s, Flashback tools allow administrator

Database administrator

A database administrator is a person responsible for the design, implementation, maintenance and repair of an organization's database. They are also known by the titles Database Coordinator or Database Programmer, and is closely related to the Database Analyst, Database Modeller, Programmer...

s and users to view and manipulate past states of an instance's data

Data

The term data refers to qualitative or quantitative attributes of a variable or set of variables. Data are typically the results of measurements and can be the basis of graphs, images, or observations of a set of variables. Data are often viewed as the lowest level of abstraction from which...

 without (destructively) recover

Data recovery

Data recovery is the process of salvaging data from damaged, failed, corrupted, or inaccessible secondary storage media when it cannot be accessed normally. Often the data are being salvaged from storage media such as internal or external hard disk drives, solid-state drives , USB flash drive,...

ing to a fixed point in time.

Flashback requires Oracle Enterprise edition.

Compare the functionality of Oracle LogMiner

Oracle LogMiner

Oracle LogMiner, a utility provided by Oracle Corporation to purchasers of its Oracle database, provides methods of querying logged changes made to an Oracle database, principally though SQL commands referencing data in Oracle redo logs...

, which identifies how and when data changed rather than its state at a given time.

External links