[MS SQL] 복구모델 변경 ERR MSG : 데이터베이스 트랜잭션 로그가 LOG_BACKUP 으로 인해 꽉 찼습니다. --> USE TABLE_NAME; ALTER DATABASE TABLE_NAME SET RECOVERY SIMPLE; DBCC shrinkdatabase( TABLE_NAME ); [오라클] 프로시저 수정 일자 확인 SELECT OBJECT_NAME, OBJECT_TYPE, STATUS, CREATED, LAST_DDL_TIME FROM USER_OBJECTS WHERE OBJECT_TYPE IN ('FUNCTION', 'PROCEDURE') --VIEW, PACKAGE BODY, TABLE .. AND TO_CHAR(LAST_DDL_TIME,'YYYYMMDD') >= '20240101' AND OBJECT_NAME LIKE '%TA%' ORDER BY OBJECT_TYPE, OBJECT_NAME; 오라클 사용중인 테이블 용량 확인 SELECT TABLE_NAME AS TB_NAME , NUM_ROWS AS ROW_CNT , NUM_ROWS * AVG_ROW_LEN AS BYTE , ROUND((NUM_ROWS * AVG_ROW_LEN / 1024 / 1024), 2) AS MB , ROUND((NUM_ROWS * AVG_ROW_LEN / 1024 / 1024 / 1024), 2) AS GB FROM ALL_TABLES 오라클 프로시저 내용 조회 SELECT T1.OBJECT_ID , T1.OBJECT_NAME , T1.OBJECT_TYPE , T2.TEXT FROM USER_OBJECTS T1 INNER JOIN USER_SOURCE T2 ON T1.OBJECT_NAME = T2.NAME WHERE UPPER(T2.TEXT) LIKE '%검색TEXT%' 이전 1 2 3 4 다음