How can i disconnet the oracle via windows batch file
791525Sep 22 2011 — edited Sep 22 2011Hi gurus,
Am trying to connect the Oracle using sys user to execute the some script, after the task has been completed the oracle have to disconnect,
Here i did the script to connect the oracle using sys user
sqlplus / as sysdba @d:\exec\Branch.sql exit;
i save the file as .bat extension.. the bat can able to connect to the oracle user as well as it can able to execute script from the specified path..
But my problem has i can't able to exit oracle via the above script.
can any please tell how can i exit the oracle .. and also suggest me the good way to connect and execute the script after the task completed the oracle will be disconnect using the window batch file ...
Operating System: windows Server 2008
Data Base: Oracle 11g R2
Thanks in advance,
Arun