Henry's powerful email pgm strips my command, it should read this
Password*connectionstring where the * should be @

-----Original Message-----
From: Allen Chan
[mailto:oracledba-ezmlmshield-x68228269.[Email address protected]
Sent: Tuesday, August 31, 2004 1:06 PM
To: LazyDBA Discussion
Subject: sqlplus in batch mod with sys user


Hi, folks:

My platform is 9i on w2k.
I tried to logon remotely with 9i client

My following cmd used to work in 8i but not in 9i anymore, any way to make
it work in 9i

Sqlplus.exe sys/[Email address protected] @sqlcmd.sql

I got ERROR:
ORA-28009: connection to sys should be as sysdba or sysoper

Then I tried
Sqlplus.exe [Email address protected] as sysdba @sqlcmd.sql

But it didn't work


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page