문서의 이전 판입니다!
TRUNCATE TABLE :TABLE_NAME;
SQL> DROP TABLE 테이블명 PURGE; SQL> DROP TABLE 테이블명 CASCADE CONSTRAINTS PURGE;
SQL> PURGE TABLE "BIN$IIM7B5WPKdLgRAASeZ4XFA==$0";
SQL> SHOW RECYCLEBIN( or SHOW RECYCLE ) SQL> PURGE RECYCLEBIN
ANALYZE TABLE :TABLE_NAME DELETE STATISTICS; ANALYZE TABLE :TABLE_NAME COMPUTE STATISTICS; SELECT TABLE_NAME,GREATEST(4, CEIL(NUM_ROWS/ ((ROUND(((1958-(INI_TRANS*23))*((100-PCT_FREE)/100))/AVG_ROW_LEN)))) * 2048) TABLESIZE_KBYTES FROM USER_TABLES WHERE TABLE_NAME -- WHERE AVG_ROW_LEN > 0