-
I am writing a bacth file which is as below.
SVRMGRL
CONNECT internal/oracle@aaaa
select * from v$database
But as soon as SVRMGRL it doesn't type the next command
How to reslove this..?
Please help
Thanks
Harry
-
In windows you have to do the foll to run a batch file:
put all the commands starting from connect internal into a sql script for eg: data.sql:
connect internal
select * from v$datafile;
exit;
and then run another batch script like :
%ORACLE_HOME%/bin/svrmgrl @data.sql
I think this will work.
KN
-
I couldn't understand this
How can I define the sql script to run in SVRMGRL.
Explain in detail.
Thanks
Harry
-
Hi
You have to make two bacth files.
1. startup.bat
---------------
svrmgrl @s.sql
2. s.sql
----------------
connect internal
Then when ever you run the startup.bat, the the file s.sql will be executed. Try it..!
Thomas
-
My advice is " not to use svrmgrl and connect internal", since these commands are deprciated in Oracle9i, so use sqlplus which will make your script compatible to new Oracle version also.
If you are using Unix.
try
sqlplus <
connect scott/tiger@instance
select * from dept;
EOF
Sanjay
OCP 8i
-
AT Cmd
Hi,
u can try scheduler on NT. an execute the sql command file as below
sqlplus internal file.sql
this works if u r using od authenticatio otherwise
sqlplus user/pwd file.sql
vijay
--------------------------
The Time has come ....
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|