[SQL ] 關於oraclescript
因為我們用win版的oracle做作業
可是老師給我們一個linux版的script
現在不知該怎麼處理
有大師可以幫我們看一下
怎麼改才能是win可以執行的呢???
lab_02_copy.sh
以下
- - Oracle Database 10g: Administration Workshop II
- - Oracle Server Technologies - Curriculum Development
- -
- - ***Training purposes only***
- - ***Not appropriate for production use***
- - Shutdown the database
echo Shutting down the database...
sqlplus / as sysdba <<EOF
set echo on
shutdown immediate
EOF
- - Copy datafiles
echo Copying datafiles...
cp E:\oracle\product\10.2.0\oradata\ORCL/*.* ~/DONTTOUCH
- - Startup the database
echo Starting the instance...
sqlplus / as sysdba <<EOF
set echo on
startup
EOF
echo Finished.
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.125.90.93
推
03/23 20:25, , 1F
03/23 20:25, 1F