Flashback Drop + Recyclebin


Flashback technology that comes with Oracle 10g offers many features. 

**ORACLE FLASHBACK DROP
**ORACLE FLASHBACK TABLE
**ORACLE FLASHBACK DATABASE
**ORACLE FLASHBACK QUERY
**ORACLE TRANSACTION QUERY
**ORACLE FLASHBACK VERSION QUERY

Best Practical
 
SQL>show parameter recyclebin
NAME                 TYPE        VALUE
————–          ———–       ——-
recyclebin             string            on
 
SQL> conn anar/oracle
Connected.
 

SQL> create table test_table as select * from all_tables;
Table created.
                                                         
SQL> select count(*) from test_table;
COUNT(*)
———-
2776
 

SQL> drop table test_table;
Table dropped.
 

SQL> select object_name,original_name,type from recyclebin;
  OBJECT_NAME                                         ORIGINAL_NAME                    TYPE
——————————                                ——————————–            ————-
BIN$nQP9uzDl8cvgQAB/AQAbPw==$0      TEST_TABLE                    TABLE
 

SQL> select * from test_table;
ERROR at line 1:
ORA-00942: table or view does not exist
 

SQL> select count(*) from “BIN$nQP9uzDl8cvgQAB/AQAbPw==$0″;
COUNT(*)
———-
2776
 

SQL> flashback table test_table to before drop;
Flashback complete.
 

SQL> select count(*) from test_table;
COUNT(*)
———-
2776
 
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: