사용자 도구

사이트 도구


dbms:oracle:admin:flashback:recyclebin

recycle bin

  1. 동일한 테이블을 생성 삭제를 반복한다
    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;
  2. 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';
  3. 휴지통에서 테이블을 복구한다.
    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;
dbms/oracle/admin/flashback/recyclebin.txt · 마지막으로 수정됨: 2016/05/21 16:36 저자 starlits