rebuild.bat

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

sqlplus dyt/sql@dytsms @offline.sql                                                                                                                                                                                                                            
mkdir \a\b\c\d c:\oracle\data\                                                                                                                                                                                                                                 
move C:\ORACLE\ORADATA\DYTSMS\MSUSER\HISTORY01.DBF c:\oracle\data\                                                                                                                                                                                             
move C:\ORACLE\ORADATA\DYTSMS\MSUSER\HISTORY02.DBF c:\oracle\data\                                                                                                                                                                                             
move C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER130.DBF c:\oracle\data\                                                                                                                                                                                           
move C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER131.DBF c:\oracle\data\                                                                                                                                                                                           
move C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER133.DBF c:\oracle\data\                                                                                                                                                                                           
move C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER135.DBF c:\oracle\data\                                                                                                                                                                                           
move C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER136.DBF c:\oracle\data\                                                                                                                                                                                           
move C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER137.DBF c:\oracle\data\                                                                                                                                                                                           
move C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER138.DBF c:\oracle\data\                                                                                                                                                                                           
move C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSER139.DBF c:\oracle\data\                                                                                                                                                                                           
move C:\ORACLE\ORADATA\DYTSMS\MSUSER\ROAMUSERXXX.DBF c:\oracle\data\                                                                                                                                                                                           
move C:\ORACLE\ORADATA\DYTSMS\MSUSER\STAT01.DBF c:\oracle\data\                                                                                                                                                                                                
move C:\ORACLE\ORADATA\DYTSMS\MSUSER\STAT02.DBF c:\oracle\data\                                                                                                                                                                                                
move C:\ORACLE\ORADATA\DYTSMS\MSUSER\STAT03.DBF c:\oracle\data\                                                                                                                                                                                                
move C:\ORACLE\ORADATA\DYTSMS\MSUSER\STAT04.DBF c:\oracle\data\                                                                                                                                                                                                
sqlplus dyt/sql@dytsms @online.sql