[ORACLE SQL]계정 테이블 깔끔하게 다 날리기

SELECT  'DROP TABLE ' || object_name || ' CASCADE CONSTRAINTS;'
FROM    user_objects
WHERE   object_type = 'TABLE';

해당 쿼리문을 실행해서 나오는 쿼리문을 실행한다. 

 

그러면 테이블을 다 날리고, 

 

SHOW RECYCLEBIN;
PURGE RECYCLEBIN;

마지막으로 해당 쿼리문으로 쓰레기통도 확인해서 비워준다 

 

 

SELECT  'DROP TABLE ' || object_name || ' CASCADE CONSTRAINTS;'
FROM    user_objects
WHERE   object_type = 'TABLE';

DROP TABLE WORK CASCADE CONSTRAINTS;
DROP TABLE WK_RCD CASCADE CONSTRAINTS;
DROP TABLE WK_AP CASCADE CONSTRAINTS;
DROP TABLE WAGE_ACCT CASCADE CONSTRAINTS;
DROP TABLE VAC_SCH CASCADE CONSTRAINTS;
DROP TABLE VAC_POSN CASCADE CONSTRAINTS;
DROP TABLE VAC_APLY CASCADE CONSTRAINTS;
DROP TABLE VAC CASCADE CONSTRAINTS;
DROP TABLE TRVEX_APLY CASCADE CONSTRAINTS;
DROP TABLE TRIB_APLY CASCADE CONSTRAINTS;
DROP TABLE RW_APLY CASCADE CONSTRAINTS;
DROP TABLE RPT CASCADE CONSTRAINTS;
DROP TABLE RECIEPT CASCADE CONSTRAINTS;
DROP TABLE PTMAKE CASCADE CONSTRAINTS;
DROP TABLE PTEMP CASCADE CONSTRAINTS;
DROP TABLE PSTN CASCADE CONSTRAINTS;
DROP TABLE PROB CASCADE CONSTRAINTS;
DROP TABLE PEX_DM CASCADE CONSTRAINTS;
DROP TABLE PENSION CASCADE CONSTRAINTS;
DROP TABLE PAYTPL CASCADE CONSTRAINTS;
DROP TABLE PAYROLL CASCADE CONSTRAINTS;
DROP TABLE PAYRCD CASCADE CONSTRAINTS;
DROP TABLE PAY CASCADE CONSTRAINTS;
DROP TABLE OWN_JOB CASCADE CONSTRAINTS;
DROP TABLE OWN_DUTY CASCADE CONSTRAINTS;
DROP TABLE NOTICE CASCADE CONSTRAINTS;
DROP TABLE JOB CASCADE CONSTRAINTS;
DROP TABLE INC_CERF CASCADE CONSTRAINTS;
DROP TABLE ID CASCADE CONSTRAINTS;
DROP TABLE ICMTAX CASCADE CONSTRAINTS;
DROP TABLE HRNOTE CASCADE CONSTRAINTS;
DROP TABLE HDAY CASCADE CONSTRAINTS;
DROP TABLE GRD CASCADE CONSTRAINTS;
DROP TABLE FILE_DETAIL CASCADE CONSTRAINTS;
DROP TABLE FEX_HX CASCADE CONSTRAINTS;
DROP TABLE EQT_APLY CASCADE CONSTRAINTS;
DROP TABLE EMP_FAM CASCADE CONSTRAINTS;
DROP TABLE EMPT CASCADE CONSTRAINTS;
DROP TABLE EMP CASCADE CONSTRAINTS;
DROP TABLE DUTY CASCADE CONSTRAINTS;
DROP TABLE DOC_WRI CASCADE CONSTRAINTS;
DROP TABLE DEPT_SCD CASCADE CONSTRAINTS;
DROP TABLE DEPT CASCADE CONSTRAINTS;
DROP TABLE DED CASCADE CONSTRAINTS;
DROP TABLE CTRV_REQ CASCADE CONSTRAINTS;
DROP TABLE COMPANY CASCADE CONSTRAINTS;
DROP TABLE CNTHX CASCADE CONSTRAINTS;
DROP TABLE CNT CASCADE CONSTRAINTS;
DROP TABLE CMCODE CASCADE CONSTRAINTS;
DROP TABLE CERT_POSN CASCADE CONSTRAINTS;
DROP TABLE CAREER CASCADE CONSTRAINTS;
DROP TABLE BLG_DEPT CASCADE CONSTRAINTS;
DROP TABLE BK_APLY CASCADE CONSTRAINTS;
DROP TABLE BDFT CASCADE CONSTRAINTS;
DROP TABLE ATTEND CASCADE CONSTRAINTS;
DROP TABLE ASGMT_DFT CASCADE CONSTRAINTS;
DROP TABLE ASGMT CASCADE CONSTRAINTS;
DROP TABLE ASC_LOG CASCADE CONSTRAINTS;
DROP TABLE ARM CASCADE CONSTRAINTS;
DROP TABLE APLINE CASCADE CONSTRAINTS;
DROP TABLE ACCA CASCADE CONSTRAINTS;


SHOW RECYCLEBIN;
PURGE RECYCLEBIN;