offline.sql

来自「本人在工程上收集的比较常用的oracle sql语句 有问题请发email:l」· SQL 代码 · 共 23 行

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;