offline.sql

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

alter database datafile 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\HISTORY01.DBF' offline;                           alter database datafile 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\HISTORY02.DBF' offline;                           alter database datafile 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER130.DBF' offline;                         alter database datafile 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER131.DBF' offline;                         alter database datafile 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER133.DBF' offline;                         alter database datafile 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER135.DBF' offline;                         alter database datafile 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER136.DBF' offline;                         alter database datafile 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER137.DBF' offline;                         alter database datafile 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER138.DBF' offline;                                                                                                                                                                             
                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                               
alter database datafile 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER139.DBF' offline;                                                                                                                                                                             
                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                               
alter database datafile 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSERXXX.DBF' offline;                                                                                                                                                                             
                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                               
alter database datafile 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\STAT01.DBF' offline;                                                                                                                                                                                  
                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                               
alter database datafile 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\STAT02.DBF' offline;                                                                                                                                                                                  
                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                               
alter database datafile 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\STAT03.DBF' offline;                                                                                                                                                                                  
                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                               
alter database datafile 'C:\ORACLE\ORADATA\DYTSMS\MSUSER\STAT04.DBF' offline;                                                                                                                                                                                  
                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                               
quit;