I am Sharing my experience in recovery table from recyclebin
SQL> select object_name, original_name, type,droptime from recyclebin;
OBJECT_NAME ORIGINAL_NAME TYPE DROPTIME
————————————- ————————– ———— ————————
BIN$RVdHjbBfXI3gUwIAAH/nrg==$0 T1 TABLE 2016-09-05:01:32:05
BIN$RVVsfQkeTzfgUwIAAH8GCw==$0 T1 TABLE 2016-09-05:01:35:36
Here we can use two ways to restore the table
STEP 1:
This will restore the latest drop table to restore.
SQL> flashback table t1 to before drop;
Flashback complete.
STEP 2:
The below command to restore the selected recyclebin object to restore.
SQL> flashback table “BIN$RVdHjbBfXI3gUwIAAH/nrg==$0" to before drop;
Flashback complete.
SQL>
No comments:
Post a Comment