online.sql

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

                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                               
alter database datafile  'c:\oracle\data\ROAMUSER136' online;                                                                                                                                                                                                  
                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                               
alter database datafile  'c:\oracle\data\ROAMUSER137' online;                                                                                                                                                                                                  
                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                               
alter database datafile  'c:\oracle\data\ROAMUSER138' online;                                                                                                                                                                                                  
                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                               
alter database datafile  'c:\oracle\data\ROAMUSER139' online;                                                                                                                                                                                                  
                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                               
alter database datafile  'c:\oracle\data\ROAMUSERXXX' online;                                                                                                                                                                                                  
                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                               
alter database datafile  'c:\oracle\data\STAT01' online;                                                                                                                                                                                                       
                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                               
alter database datafile  'c:\oracle\data\STAT02' online;                                                                                                                                                                                                       
                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                               
alter database datafile  'c:\oracle\data\STAT03' online;                                                                                                                                                                                                       
                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                               
alter database datafile  'c:\oracle\data\STAT04' online;                                                                                                                                                                                                       
                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                               
quit;