"LOB 테이블 관리"의 두 판 사이의 차이

1 LOB 사이즈 조회[편집]

SELECT TABLE_NAME
      , sum(bytes)
   FROM (SELECT B.table_name AS table_name
              , A.bytes
           FROM DBA_SEGMENTS A
              , DBA_LOBS B
          WHERE A.segment_name = B.segment_name
            AND EXISTS (SELECT 1
                 FROM MIG_TABLES C
                WHERE C.TABLE_NAME = B.TABLE_NAME
                  AND C.OWNER      = B.OWNER
                  AND C.SYSTEM_CODE = 'LC1'
                  AND C.USE_YN = 'Y'
              )     
                          
          )
group by table_name;

2 LOB 테이블 컬럼 변경[편집]

alter table EMP modify LOB(EMP_TEXT컬럼) (nocache nologging); -- nocache , nologgin 으로 변경