[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명';