[Flashback] - Drop Table 복구

Drop Table 복구 방법 

 

-- ##################################################
-- DROP TABLE 복구 (FLASHBACK 기능을 이용)
-- ##################################################
 
-- 테이블 DROP !!
DROP TABLE ORAKIM.EMP1;
 
-- # DBA 수행
-- ORIGINAL_NAME 조회
SELECT OWNER,ORIGINAL_NAME,OBJECT_NAME,TYPE,DROPTIME FROM DBA_RECYCLEBIN ORDER BY DROPTIME DESC;
FLASHBACK TABLE ORAKIM.EMP1 TO BEFORE DROP;
 
-- # OWNER 수행
--방법1.휴지통 확인
SQL>SHOW RECYCLEBIN
SQL>FLASHBACK TABLE <삭제된 테이블명> TO BEFORE DROP;
 
--방법2.OBJECT_NAME 조회
SELECT * FROM RECYCLEBIN WHERE ORIGINAL_NAME LIKE 'EMP1';
FLASHBACK TABLE "BIN$+OQPCWSMSMGR2462A9VXZW==$0" TO BEFORE DROP;