 |
|
Oracle Tips by Burleson |
Oracle 10g Flashback Table
Flashback Table allows you to recover a table or
tables to a specific point in time without restoring a backup. When
you use the Flashback Table feature to restore a table to a specific
point in time, all associated objects, such as indexes, constraints,
and triggers will be restored.
Flashback Table operations are not valid for
the following object types:
-
Tables that are part of a cluster
-
Materialized views
-
Advanced Queuing tables
-
Static data dictionary tables
-
System tables
-
Partitions of a table
-
Remote tables (via database link)
Flashback Table is extremely useful when a user
accidentally inserts, deletes, or updates the wrong rows in a
table. It provides a way for users to easily and quickly recover a
table to a previous point in time.
However, if the following DDL commands are
issued, the flashback table command does not work:
Get the complete Oracle10g story:
To get the code instantly, click here:
Need an Oracle Mentor?
BEI is now offering personal mentors for Oracle DBAs where you can have an
Oracle expert right at your fingertips, anytime day or night. We work with
hundreds of Oracle databases every year, so we know exactly how to quickly
assist you with any Oracle question.
Why risk an unplanned outage? You can now get telephone access to Don
Burleson or any of his Oracle Certified DBAs with more than 20 years of
full-time IT experience. Click here for details:
http://www.dba-oracle.com/service_oracle_backup.htm
|
