Is this a white elephant...

what is unloadto ???

Looks like were missing an important bit...

Matthew S. Donovan
System Administrator
EDW Technology Ltd.
01908 353 326
[Email address protected]



"Choudhry Deepak "
<oracledba-ezmlmshield-x17085836.[Email address protected]
07/04/2005 13:13

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
Need Help






Hi Gurus,

I need help


I just want to know when the below Error Comes


Usage: SQLPLUS [ [<option>] [<logon>] [<start>] ]
where <option> ::= - | -? | [ [-M <o>] [-R <n>] [-S] ]
<logon> ::= <username>[/<password>][@<connect_string>] | / |
/NOLOG
<start> ::= @<filename>[.<ext>] [<parameter> ...]
"-" displays the usage syntax
"-?" displays the SQL*Plus version banner
"-M <o>" uses HTML markup options <o>
"-R <n>" uses restricted mode <n>
"-S" uses silent mode


I have been getting this error while connecting to database.

# USRPWD used by unloadto and plsql
export USRPWD="$DBSCHEMA/$[Email Address Removed] "USRPWD = $USRPWD"

DATE=`date +%Y%m%d`
SQLCOMMAND= `cat Norway.sql`
echo "$SQLCOMMAND"

unloadto output.txt <<END
$SQLCOMMAND
END


This is the Script which is failing because of SQLPLUS


Thanks and Regards
Deepak Choudhary



--------
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


Email has been scanned for viruses by www.emf-systems.com


Email has been scanned for viruses by www.emf-systems.com

Oracle LazyDBA home page