[오라클] LOB TABLESPACE MOVE 쿼리 생성 select 'alter table OWNER.' || TABLE_NAME || ' move lob(' || PATH# || ') store as (tablespace MOVETS);'from (select table_name,substr(max(sys_connect_by_path(column_name,',')),2) as path#from (select table_name,column_name,row_number() over(partition by table_name order by column_name) as ordfrom DBA_TAB_COLUMNSwhere TABLE_NAME in (select table_namefrom DBA_TABLESwhere tablespace_name = 'ORIGTS'.. 더보기 이전 1 2 3 4 5 6 7 ··· 182 다음