https://www.adminschool.net/wiki/ 2026-04-22T09:23:48+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:oracletip:alltabletruncate&rev=1759498250&do=diff 전체테이블 TRUNCATE하는 쿼리 만들기 SQL> select 'truncate table '||table_name||';' from user_tables where table_name not in ('TEMPLATE_XML','QUESTION_XML') order by table_name asc; 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:oracletip:noconnectfromsys&rev=1759498250&do=diff 오라클이 설치된 OS에서 / as sysdba 로 접속 막는방법 * 오라클이 설치된 OS에서 connect / as sysdba 접속할때 dba 그룹사용자가 sysdba 권한일때 패스워드 인증없이 접속이 가능합니다. * 보안문제상 sysdba 권한으로 접속하기를 원할때 사용하는 방법입니다. 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:oracletip:sessionkillscript&rev=1759498250&do=diff 특정 머신에서 연결된 세션 죽이기 절차 * twas2, twas3로 연결된 세션을 죽이는 스크립트를 작성한다. $ cat create_session_kill_script.sql spool session_kill.sql set pages 300 select 'alter system kill SESSION '''|| SID ||','|| SERIAL# ||''';' from v$session where machine in ('twas2','twas3') / spool off exit 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:oracletip:tablecommentdefine&rev=1759498250&do=diff 테이블 정의를 출력해주는 쿼리 SQL> SELECT TC.TABLE_NAME ,TCOMMENT.COMMENTS AS KOR_TNAME ,TC.COLUMN_NAME ,CCOMMENT.COMMENTS AS KOR_CNAME ,TC.DATA_TYPE||'('||TC.DATA_LENGTH||')' ,DECODE(PK.CT,'P','PK','') AS PK ,DECODE(TC.NULLABLE,'N','NOT NULL','') AS NOT_NULL ,TC.DATA_DEFAULT,'' AS ETC FROM USER_TAB_COLUMNS TC ,USER_COL_COMMENTS CCOMMENT ,USER_TAB_COMMENTS TCOMMENT ,( SELECT CCOL.TABLE_NAME,CCOL.COLUMN_NAME,UC.CONSTRAINT_TYPE CT FROM USER_CONS_COLUMNS CCOL,USER_C… 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:oracletip:tablecreatedate&rev=1759498250&do=diff Table 생성시기를 알아오는 쿼리 SQL> SELECT OWNER,OBJECT_NAME,CREATED FROM DBA_OBJECTS WHERE CREATED > '2006-08-31' AND OWNER NOT IN ('SYS') AND OBJECT_TYPE = 'TABLE' ORDER BY OWNER,CREATED ASC;