result.sql

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

SET ECHO      ON;                                                               
create tablespace  SYSTEM                                                       
 datafile D:\ORACLE\ORADATA\DYTSMS\SYSTEM01.DBF SIZE 73M REUSE                  
 DEFAULT STORAGE (INITIAL 64K NEXT 64K MaxEXTENTS 2147483645 MinEXTENTS 1 PCTINC
REASE 50);                                                                      
                                                                                
create tablespace  RBS                                                          
 datafile D:\ORACLE\ORADATA\DYTSMS\RBS01.DBF SIZE 520M REUSE                    
 DEFAULT STORAGE (INITIAL 512K NEXT 512K MaxEXTENTS 4096 MinEXTENTS 8 PCTINCREAS
E 50);                                                                          
                                                                                
create tablespace  USERS                                                        
 datafile D:\ORACLE\ORADATA\DYTSMS\USERS01.DBF SIZE 108M REUSE                  
 DEFAULT STORAGE (INITIAL 128K NEXT 128K MaxEXTENTS 4096 MinEXTENTS 1 PCTINCREAS
E 0);                                                                           
                                                                                
create tablespace  TEMP                                                         
 datafile D:\ORACLE\ORADATA\DYTSMS\TEMP01.DBF SIZE 72M REUSE                    
 DEFAULT STORAGE (INITIAL 64K NEXT 64K MaxEXTENTS  MinEXTENTS 1 PCTINCREASE 0); 
                                                                                
create tablespace  TOOLS                                                        
 datafile D:\ORACLE\ORADATA\DYTSMS\TOOLS01.DBF SIZE 12M REUSE                   
 DEFAULT STORAGE (INITIAL 32K NEXT 32K MaxEXTENTS 4096 MinEXTENTS 1 PCTINCREASE 
0);                                                                             
                                                                                
create tablespace  INDX                                                         
 datafile D:\ORACLE\ORADATA\DYTSMS\INDX01.DBF SIZE 58M REUSE                    
 DEFAULT STORAGE (INITIAL 128K NEXT 128K MaxEXTENTS 4096 MinEXTENTS 1 PCTINCREAS
E 0);                                                                           
                                                                                
create tablespace  ROAMUSER130                                                  
 datafile D:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER130.DBF SIZE 10M REUSE        
 DEFAULT STORAGE (INITIAL 40K NEXT 40K MaxEXTENTS 505 MinEXTENTS 1 PCTINCREASE 5
0);                                                                             
                                                                                
create tablespace  ROAMUSER131                                                  
 datafile D:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER131.DBF SIZE 10M REUSE        
 DEFAULT STORAGE (INITIAL 40K NEXT 40K MaxEXTENTS 505 MinEXTENTS 1 PCTINCREASE 5
0);                                                                             
                                                                                
create tablespace  ROAMUSER133                                                  
 datafile D:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER133.DBF SIZE 10M REUSE        
 DEFAULT STORAGE (INITIAL 40K NEXT 40K MaxEXTENTS 505 MinEXTENTS 1 PCTINCREASE 5
0);                                                                             
                                                                                
create tablespace  ROAMUSER135                                                  
 datafile D:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER135.DBF SIZE 10M REUSE        
 DEFAULT STORAGE (INITIAL 40K NEXT 40K MaxEXTENTS 505 MinEXTENTS 1 PCTINCREASE 5
0);                                                                             
                                                                                
create tablespace  ROAMUSER136                                                  
 datafile D:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER136.DBF SIZE 10M REUSE        
 DEFAULT STORAGE (INITIAL 40K NEXT 40K MaxEXTENTS 505 MinEXTENTS 1 PCTINCREASE 5
0);                                                                             
                                                                                
create tablespace  ROAMUSER137                                                  
 datafile D:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER137.DBF SIZE 10M REUSE        
 DEFAULT STORAGE (INITIAL 40K NEXT 40K MaxEXTENTS 505 MinEXTENTS 1 PCTINCREASE 5
0);                                                                             
                                                                                
create tablespace  ROAMUSER138                                                  
 datafile D:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER138.DBF SIZE 10M REUSE        
 DEFAULT STORAGE (INITIAL 40K NEXT 40K MaxEXTENTS 505 MinEXTENTS 1 PCTINCREASE 5
0);                                                                             
                                                                                
create tablespace  ROAMUSER139                                                  
 datafile D:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER139.DBF SIZE 10M REUSE        
 DEFAULT STORAGE (INITIAL 40K NEXT 40K MaxEXTENTS 505 MinEXTENTS 1 PCTINCREASE 5
0);                                                                             
                                                                                
create tablespace  ROAMUSERXXX                                                  
 datafile D:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSERXXX.DBF SIZE 10M REUSE        
 DEFAULT STORAGE (INITIAL 40K NEXT 40K MaxEXTENTS 505 MinEXTENTS 1 PCTINCREASE 5
0);                                                                             
                                                                                
create tablespace  HISTORY01                                                    
 datafile D:\ORACLE\ORADATA\DYTSMS\MSUSER\HISTORY01.DBF SIZE 10M REUSE          
 DEFAULT STORAGE (INITIAL 40K NEXT 40K MaxEXTENTS 505 MinEXTENTS 1 PCTINCREASE 5
0);                                                                             
                                                                                
create tablespace  HISTORY02                                                    
 datafile D:\ORACLE\ORADATA\DYTSMS\MSUSER\HISTORY02.DBF SIZE 10M REUSE          
 DEFAULT STORAGE (INITIAL 40K NEXT 40K MaxEXTENTS 505 MinEXTENTS 1 PCTINCREASE 5
0);                                                                             
                                                                                
create tablespace  STAT01                                                       
 datafile D:\ORACLE\ORADATA\DYTSMS\MSUSER\STAT01.DBF SIZE 10M REUSE             
 DEFAULT STORAGE (INITIAL 40K NEXT 40K MaxEXTENTS 505 MinEXTENTS 1 PCTINCREASE 5
0);                                                                             
                                                                                
create tablespace  HISTORY04                                                    
 datafile D:\ORACLE\ORADATA\DYTSMS\MSUSER\HISTORY04.DBF SIZE 10M REUSE          
 DEFAULT STORAGE (INITIAL 40K NEXT 40K MaxEXTENTS 505 MinEXTENTS 1 PCTINCREASE 5
0);                                                                             
                                                                                
create tablespace  STAT02                                                       
 datafile D:\ORACLE\ORADATA\DYTSMS\MSUSER\STAT02.DBF SIZE 10M REUSE             
 DEFAULT STORAGE (INITIAL 40K NEXT 40K MaxEXTENTS 505 MinEXTENTS 1 PCTINCREASE 5
0);                                                                             
                                                                                
create tablespace  STAT03                                                       
 datafile D:\ORACLE\ORADATA\DYTSMS\MSUSER\STAT03.DBF SIZE 10M REUSE             
 DEFAULT STORAGE (INITIAL 40K NEXT 40K MaxEXTENTS 505 MinEXTENTS 1 PCTINCREASE 5
0);                                                                             
                                                                                
create tablespace  STAT04                                                       
 datafile D:\ORACLE\ORADATA\DYTSMS\MSUSER\STAT04.DBF SIZE 10M REUSE             
 DEFAULT STORAGE (INITIAL 40K NEXT 40K MaxEXTENTS 505 MinEXTENTS 1 PCTINCREASE 5
0);                                                                             
                                                                                
quit;