진한 커피 향기

with temp as( select '1' idx , '10' dept , '20170703' as lastm ,'기타' as data_etc from dual union all select '2' idx , '20' dept , '20170704' as lastm ,'정상' as data_etc from dual union all select '2' idx , '20' dept , '20170705' as lastm ,'비정상' as data_etc from dual union all select '3' idx , '40' dept , '20170703' as lastm ,'기타' as data_etc from dual union all select '3' idx , '40' dept , '20170..

alter index [DBSCCOM01.PK_WR_TB010] rebuild; [0000] < - indexname -- 인덱스 상태가 안좋은거 찾기 select index_owner,index_name,partition_name,STATUS from dba_ind_partitions where index_owner='BILL'