Oracle Database 10g provides a new SQL DDL command to restore the state of a table to an earlier point in time in case the table was manipulated unintentionally. Users can invoke 'Flashback' table command on one or more tables.
sql> Drop table xxcust_reports;
Table Dropped.
sql>Flashback table xxcust_reports to before drop;
Flashback Complete.
Please note that we also have the luxury of looking at the drop changes to the table using 'recylebin'
sql>select original_name, operation, drop_time from recyclebin;
-Suman
sql> Drop table xxcust_reports;
Table Dropped.
sql>Flashback table xxcust_reports to before drop;
Flashback Complete.
Please note that we also have the luxury of looking at the drop changes to the table using 'recylebin'
sql>select original_name, operation, drop_time from recyclebin;
-Suman
No comments:
Post a Comment