Re: Executing a SQL from svrmgr from command line

Praveen Mohanan wrote in message
<942861734.224930_at_sj-nntpcache-2.cisco.com>...
> I wanted to execute one few commands from the command line & exit at the
>end. For eg
>
>1. invoke srvmgr
>2. connect internal
>3. run a SQL script
>4. exit
>
>How can i write this in a shell script, so that if i call the shell, it
will
>run all these command & come back to the prompt.

• sample script -- #!/bin/sh

# usage : $0 <sqlscript>

svrmgrl << EOF
connect internal
@$1
exit
EOF
-- sample script --

To run the above script, assuming it's name is foo and we want to execute SQL script db_start.sql:
/home/oracle> foo db_start.sql

regards,
Billy Received on Thu Nov 18 1999 - 00:20:52 CST