rebuild.sql

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

  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.STAT_CITY_IDX                |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.STAT_CITY_IDX                                                   
REBUILD                                                                         
TABLESPACE USERS                                                                
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.SYS_C003078                  |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.SYS_C003078                                                     
REBUILD                                                                         
TABLESPACE USERS                                                                
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.SYS_C003083                  |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.SYS_C003083                                                     
REBUILD                                                                         
TABLESPACE SYSTEM                                                               
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.SYS_C003082                  |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.SYS_C003082                                                     
REBUILD                                                                         
TABLESPACE SYSTEM                                                               
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.SYS_C003081                  |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.SYS_C003081                                                     
REBUILD                                                                         
TABLESPACE SYSTEM                                                               
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.CONDITION_HLRID_IDX          |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.CONDITION_HLRID_IDX                                             
REBUILD                                                                         
TABLESPACE SYSTEM                                                               
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.CONDITION_VLRID_IDX          |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.CONDITION_VLRID_IDX                                             
REBUILD                                                                         
TABLESPACE SYSTEM                                                               
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.CONDITION_ROAMTYPE_IDX       |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.CONDITION_ROAMTYPE_IDX                                          
REBUILD                                                                         
TABLESPACE SYSTEM                                                               
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.CONDITION_USERID_IDX         |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.CONDITION_USERID_IDX                                            
REBUILD                                                                         
TABLESPACE SYSTEM                                                               
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.SYS_C003080                  |