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 |