sqlplus -s [message #7964] |
Fri, 18 July 2003 15:02 |
LASCOLI
Messages: 18 Registered: November 2002
|
Junior Member |
|
|
I am attempting to run sqlplus -s from a Linux shell the result is as follows;
sqlplus -S crr_reps1.txt
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
The file crr_reps1.txt simplies executes a procedure.I I have inlcuded the username/password
cat crr_reps1.txt
dbimpl/'password'
exec CDE_RTE_CSV;
exit
I have been searching for the syntax to assume the correct username and password, but have been able to come up with it.Eventually I want to add a crontab entry to run this daily. Any assistance would be most welcomed. Thanks
|
|
|
Re: sqlplus -s [message #7978 is a reply to message #7964] |
Sun, 20 July 2003 10:49 |
DD
Messages: 12 Registered: January 2003
|
Junior Member |
|
|
you need to give the username password at the command prompt itself.
the syntax is
sqlplus -s userid/password @sqlfile.sql
You must supply the username/password as part of the command line since sqlplus expects it there.
Also u need to put an @ sign before the filename (@sqlfile.sql) so that sqlplus knows it needs to be excuted.
HTH
DD
|
|
|