鏃犺浠€涔堟儏鍐碉紝鐜板湪鎴戜滑涓€涓敤鎴風殑鏁版嵁瀛樺湪浜庡涓〃絀洪棿閲岋紝鐜板湪鎯蟲妸鏁版嵁緇熶竴鏀懼湪涓€涓〃絀洪棿閲?/p>

2.濡備綍緇熶竴鏁版嵁琛ㄥ悓涓€涓〃絀洪棿錛屽茍淇濊瘉浠ュ悗鍚屼竴涓敤鎴風殑鏁版嵁淇濆瓨鍦ㄤ竴涓〃絀洪棿錛?/p>

    2.1绱㈠紩榪佺Щ

        鍛戒護錛欰LTER INDEX BMI_ACCOUNTS REBUILD TABLESPACE DEMO;

        鐢熸垚鐢ㄦ埛涓鎵€鏈夌儲寮曡縼縐葷殑鍛戒護錛?/p>

        SELECT 'ALTER INDEX '||INDEX_NAME||' REBUILD TABLESPACE DEMO;' FROM USER_INDEXES WHERE TABLESPACE_NAME='EXAMPLE';

    2.2琛ㄨ縼縐?/p>

鍛戒護錛欰LTER TABLE ACCOUNTS MOVE TABLESPACE DEMO

鐢熸垚鐢ㄦ埛涓鎵€鏈夎〃榪佺Щ鐨勫懡浠わ細

SELECT 'ALTER TABLE '||TABLE_NAME||' MOVE TABLESPACE DEMO;' FROM USER_TABLES WHERE TABLESPACE_NAME='EXAMPLE';

榪炲悓LOB瀛楁涓€璧瘋縼縐誨懡浠わ細

ALTER TABLE test MOVE TABLESPACE test LOB (DATAPOLLIOR) STORE AS (TABLESPACE test);

3.绱㈠紩縐誨姩鍚庡彲鑳藉嚭鐜扮儲寮曟棤鏁堢殑鎯呭喌錛岃繖鏃墮渶瑕侀噸鏂板緩绔嬬儲寮?/p>

-- 璇蜂互 DBA 鏉冮檺鐧誨綍,騫舵墽琛?nbsp;
-- 灝嗘墍鏈?UNUSABLE 鐘舵€佺殑 index 淇, rebuild 涓€涓嬪嵆鍙?nbsp;
declare 
  -- 鎸囧悜鎵€鏈?UNUSABLE 鐘舵€佺殑 index 鐨勬父鏍?nbsp;
  cursor c is  
    select index_name, owner  
    from dba_indexes  
    where status='UNUSABLE'; 
   
  owner dba_indexes.owner%type; 
  index_name dba_indexes.index_name%type; 
begin 
  open c; 
  loop  
       fetch c into index_name, owner;  
       exit when c%notfound; 
        
       execute immediate 'alter index ' || owner || '.' || index_name || ' rebuild'; 
  end loop; 
  close c; 
end;