Oracle

Flashback Features

Figo Kim 2006. 12. 4. 08:18

Oracle's flashback features, which let you undo damage to your database after logical data corruption, include the following:

  • Oracle Flashback Database, which returns your entire database to a previous state without requiring you to restore files from backup;

  • Oracle Flashback Table, which returns one or more tables to their contents at a previous time;

  • Oracle Flashback Drop, which undoes the effects of the DROP TABLE operation;

  • Oracle Flashback Query, which is used to query the contents of the database at a past time;

  • Oracle Flashback Version Query, which lets you view past states of data;

  • Oracle Flashback Transaction Query, which is used to review transactions affecting a table over time.



powered by performancing firefox