rebuild.sql

本人在工程上收集的比较常用的oracle sql语句 有问题请发email:[e-mail]

SET ECHO      ON;                                                               
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.SYS_C003089                  |                           
REM | BYTES      : 4194304                          |                           
REM | EXTENTS    : 4                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.SYS_C003089                                                     
REBUILD                                                                         
TABLESPACE SYSTEM                                                               
STORAGE (                                                                       
  INITIAL     3604480                                                           
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.NO_IDX                       |                           
REM | BYTES      : 3145728                          |                           
REM | EXTENTS    : 3                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.NO_IDX                                                          
REBUILD                                                                         
TABLESPACE SYSTEM                                                               
STORAGE (                                                                       
  INITIAL     2424832                                                           
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.SYS_C003090                  |                           
REM | BYTES      : 262144                           |                           
REM | EXTENTS    : 4                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.SYS_C003090                                                     
REBUILD                                                                         
TABLESPACE SYSTEM                                                               
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.SYS_C003099                  |                           
REM | BYTES      : 131072                           |                           
REM | EXTENTS    : 2                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.SYS_C003099                                                     
REBUILD                                                                         
TABLESPACE SYSTEM                                                               
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.SYS_C003097                  |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.SYS_C003097                                                     
REBUILD                                                                         
TABLESPACE SYSTEM                                                               
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.SYS_C003100                  |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.SYS_C003100                                                     
REBUILD                                                                         
TABLESPACE SYSTEM                                                               
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.SYS_C003094                  |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.SYS_C003094                                                     
REBUILD                                                                         
TABLESPACE SYSTEM                                                               
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.SYS_C003096                  |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.SYS_C003096                                                     
REBUILD                                                                         
TABLESPACE USERS                                                                
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.HISTORY_IDX                  |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.HISTORY_IDX                                                     
REBUILD                                                                         
TABLESPACE USERS                                                                
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.SYS_C003076                  |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.SYS_C003076                                                     
REBUILD                                                                         
TABLESPACE USERS                                                                
STORAGE (