====== recycle bin ======

  - 동일한 테이블을 생성 삭제를 반복한다 <code>
create table c1 (id varchar2(10);
drop table c1;
create table c1 (id varchar2(10);
drop table c1;
create table c1 (id varchar2(10);
drop table c1;
create table c1 (id varchar2(10);
drop table c1;
create table c1 (id varchar2(10);
drop table c1;
</code>
  - recyclebin 을 조회한다<code>
show recyclebin
</code> <code>
select owner, original_name, object_name, 
       type, ts_name, droptime, space
from dba_recyclebin
where can_undrop='YES';
</code> <code>
select original_name, object_name, ts_name, droptime
from user_recyclebin 
where can_undrop='YES';
</code>
  - 휴지통에서 테이블을 복구한다. <code>
flashback table c1 to before drop;
</code><code>
flashback table c1 to before drop rename to c1_old; 
</code><code>
flashback table "BIN$M0K6lXidd4HgUAB/AQBHTg==$0" to before drop;
</code><code>
flashback table "BIN$M0K6lXidd4HgUAB/AQBHTg==$0" to before drop rename to c1_old2;
</code>