rebuild.sql

来自「本人在工程上收集的比较常用的oracle sql语句 有问题请发email:l」· SQL 代码 · 共 649 行 · 第 1/4 页

  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.LIMIT_VLR_IDX                |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.LIMIT_VLR_IDX                                                   
REBUILD                                                                         
TABLESPACE SYSTEM                                                               
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.LIMIT_CITY_IDX               |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.LIMIT_CITY_IDX                                                  
REBUILD                                                                         
TABLESPACE SYSTEM                                                               
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.SYS_C003077                  |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.SYS_C003077                                                     
REBUILD                                                                         
TABLESPACE USERS                                                                
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.STAT_IDX                     |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.STAT_IDX                                                        
REBUILD                                                                         
TABLESPACE USERS                                                                
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.HISTORY_MSISDN_IDX           |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.HISTORY_MSISDN_IDX                                              
REBUILD                                                                         
TABLESPACE USERS                                                                
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.MSGSTAT_STIME_IDX            |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.MSGSTAT_STIME_IDX                                               
REBUILD                                                                         
TABLESPACE USERS                                                                
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.SYS_C003095                  |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.SYS_C003095                                                     
REBUILD                                                                         
TABLESPACE SYSTEM                                                               
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.SYS_C003093                  |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.SYS_C003093                                                     
REBUILD                                                                         
TABLESPACE SYSTEM                                                               
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.SYS_C003098                  |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.SYS_C003098                                                     
REBUILD                                                                         
TABLESPACE SYSTEM                                                               
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
quit;