Logging into Oracle from a script

[Vic88]

I am trying to create a script that can automatically backup an oracle 9i database.

I create an batch file with the command D:\oracle9i\bin\sqlplusw.exe @h:\test.sql

Test.sql contains the command
connect connect username/password

whenever I execute the batch file sqlplus is started and the following error message is generated



SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_string>] | /


How can I get around this problem ?

Vic88

 

[dbtoo2001]

sqlplus -restrict 3 /nolog << EOF
connect sys/yourpw as sysdba
$dowhat
EOF

 

[Vic88]

I modified my original script to look like this



D:\oracle9i\bin\sqlplusw.exe /nolog @h:\test.sql

It worked.


Thanks for the insight.

Vic88