recycle bin

동일한 테이블을 생성 삭제를 반복한다

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;

recyclebin 을 조회한다

show recyclebin

select owner, original_name, object_name, 
       type, ts_name, droptime, space
from dba_recyclebin
where can_undrop='YES';

select original_name, object_name, ts_name, droptime
from user_recyclebin 
where can_undrop='YES';

휴지통에서 테이블을 복구한다.

flashback table c1 to before drop;

flashback table c1 to before drop rename to c1_old;

flashback table "BIN$M0K6lXidd4HgUAB/AQBHTg==$0" to before drop;

flashback table "BIN$M0K6lXidd4HgUAB/AQBHTg==$0" to before drop rename to c1_old2;