본문 바로가기
OraclE

flashback drop & flashback table

by 타마마임팩트_쫀 2009. 5. 26.

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

'OraclE' 카테고리의 다른 글

오라클 홈페이지 가입  (0) 2009.06.11
demobld.sql  (0) 2009.05.26
flashback database  (0) 2009.05.26
oracle enterprise manager 한글 버튼 깨짐 문제  (0) 2009.04.24
ORA 7445, 600 Trouble Shooting  (0) 2009.03.19