rebuild.sql

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

REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.SYS_C003080                                                     
REBUILD                                                                         
TABLESPACE USERS                                                                
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.SYS_C003079                  |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.SYS_C003079                                                     
REBUILD                                                                         
TABLESPACE USERS                                                                
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.SYS_C003092                  |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.SYS_C003092                                                     
REBUILD                                                                         
TABLESPACE SYSTEM                                                               
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.SYS_C003091                  |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.SYS_C003091                                                     
REBUILD                                                                         
TABLESPACE SYSTEM                                                               
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.SYS_C003088                  |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.SYS_C003088                                                     
REBUILD                                                                         
TABLESPACE USERS                                                                
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.SYS_C003087                  |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.SYS_C003087                                                     
REBUILD                                                                         
TABLESPACE USERS                                                                
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.SYS_C003086                  |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.SYS_C003086                                                     
REBUILD                                                                         
TABLESPACE USERS                                                                
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.SYS_C003085                  |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.SYS_C003085                                                     
REBUILD                                                                         
TABLESPACE USERS                                                                
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.MENU_GID_IDX                 |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.MENU_GID_IDX                                                    
REBUILD                                                                         
TABLESPACE USERS                                                                
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1                                                                 
  MAXEXTENTS  2147483645                                                        
  PCTINCREASE                                                                   
);                                                                              
                                                                                
                                                                                
REM +-----------------------------------------------+                           
REM | INDEX NAME : DYT.SYS_C003084                  |                           
REM | BYTES      : 65536                            |                           
REM | EXTENTS    : 1                                |                           
REM +-----------------------------------------------+                           
ALTER INDEX DYT.SYS_C003084                                                     
REBUILD                                                                         
TABLESPACE SYSTEM                                                               
STORAGE (                                                                       
  INITIAL     65536                                                             
  NEXT                                                                          
  MINEXTENTS  1