https://www.adminschool.net/wiki/ 2026-04-22T11:08:11+00:00 https://www.adminschool.net/wiki/ https://www.adminschool.net/wiki/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2025-10-03T13:30:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:oracle:admin:oracletablemanage:purge&rev=1759498250&do=diff Oracle 10g에서 Table Drop/Purge 시키기 * recyclebin 리스트 보기 set lines 100 set pages 200 column owner format a10 column original_name a20 column operation format a8 column type format a12 column droptime a20 select owner,original_name,operation,type,droptime from dba_recyclebin; text/html 2025-10-03T13:30:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:oracle:admin:oracletablemanage:tablesizecals&rev=1759498250&do=diff 테이블 크기를 계산해주는 SQL * 사용자별 테이블 데이타의 크기를 계산해주는 스크립트이다. 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 text/html 2025-10-03T13:30:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:oracle:admin:oracletablemanage:truncate&rev=1759498250&do=diff Table Truncate * 테이블의 내용을 깨끗히 비워주는 방법이다. TRUNCATE TABLE :TABLE_NAME;