[Oracle] 테이블 스페이스 및 Comment 관리

 

-- TABLE SPACE
SELECT OWNER, INDEX_NAME, TABLE_NAME, TABLESPACE_NAME 
  FROM ALL_INDEXES
 WHERE 1=1
   AND OWNER = 'DB소유자'
   AND TABLESPACE_NAME = '테이블스페이스명'

-- COMMENT
SELECT *
  FROM ALL_COL_COMMENTS
 WHERE TABLE_NAME LIKE '%IAIF%'
   AND COMMENTS IS NULL
   AND OWNER = 'DB소유자'
ORDER BY TABLE_NAME;


-- COMMENT 추가
COMMENT ON COLUMN "DB소유자"."테이블명"."칼럼명" IS 'comment명';