OraclE

flashback drop & flashback table

타마마임팩트_쫀 2009. 5. 26. 17:22

SQL> conn scott/tiger
Connected.
SQL>
SQL>
SQL> show recyclebin;
SQL> select * from salgrade;

     GRADE      LOSAL      HISAL
---------- ---------- ----------
         1        700       1200
         2       1201       1400
         3       1401       2000
         4       2001       3000
         5       3001       9999

SQL> drop table salgrade;

Table dropped.

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


SQL> show recyclebin;
ORIGINAL NAME    RECYCLEBIN NAME                OBJECT TYPE  DROP TIME
---------------- ------------------------------ ------------ -------------------
SALGRADE         BIN$as1FWkZPBBbgRAAMKczqrw==$0 TABLE        2009-05-26:17:11:16


SQL> flashback table salgrade to before drop;

Flashback complete.

SQL> show recyclebin;
SQL> select * from salgrade;

     GRADE      LOSAL      HISAL
---------- ---------- ----------
         1        700       1200
         2       1201       1400
         3       1401       2000
         4       2001       3000
         5       3001       9999