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