online.sql

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

alter database rename file 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\HISTORY01.DBF' to 'c:\oracle\data\HISTORY01.ORA';                                                                                                                                                  
alter database rename file 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\HISTORY02.DBF' to 'c:\oracle\data\HISTORY02.ORA';                                                                                                                                                  
alter database rename file 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER130.DBF' to 'c:\oracle\data\ROAMUSER130.ORA';                                                                                                                                              
alter database rename file 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER131.DBF' to 'c:\oracle\data\ROAMUSER131.ORA';                                                                                                                                              
alter database rename file 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER133.DBF' to 'c:\oracle\data\ROAMUSER133.ORA';                                                                                                                                              
alter database rename file 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER135.DBF' to 'c:\oracle\data\ROAMUSER135.ORA';                                                                                                                                              
alter database rename file 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER136.DBF' to 'c:\oracle\data\ROAMUSER136.ORA';                                                                                                                                              
alter database rename file 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER137.DBF' to 'c:\oracle\data\ROAMUSER137.ORA';                                                                                                                                              
alter database rename file 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER138.DBF' to 'c:\oracle\data\ROAMUSER138.ORA';                                                                                                                                              
alter database rename file 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER139.DBF' to 'c:\oracle\data\ROAMUSER139.ORA';                                                                                                                                              
alter database rename file 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSERXXX.DBF' to 'c:\oracle\data\ROAMUSERXXX.ORA';                                                                                                                                              
alter database rename file 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\STAT01.DBF' to 'c:\oracle\data\STAT01.ORA';                                                                                                                                                        
alter database rename file 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\STAT02.DBF' to 'c:\oracle\data\STAT02.ORA';                                                                                                                                                        
alter database rename file 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\STAT03.DBF' to 'c:\oracle\data\STAT03.ORA';                                                                                                                                                        
alter database rename file 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\STAT04.DBF' to 'c:\oracle\data\STAT04.ORA';                                                                                                                                                        
alter database datafile  'c:\oracle\data\HISTORY01' online;                                                                                                                                                                                                    
                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                               
alter database datafile  'c:\oracle\data\HISTORY02' online;                                                                                                                                                                                                    
                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                               
alter database datafile  'c:\oracle\data\ROAMUSER130' online;                                                                                                                                                                                                  
                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                               
alter database datafile  'c:\oracle\data\ROAMUSER131' online;                                                                                                                                                                                                  
                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                               
alter database datafile  'c:\oracle\data\ROAMUSER133' online;                                                                                                                                                                                                  
                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                               
alter database datafile  'c:\oracle\data\ROAMUSER135' online;