Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SqlLoader
Stupid
question I know but is the correct SID set ??
<SPAN
class=765525809-13122001>
and
watch out for TWO_TASK !!!!!!
<SPAN
class=765525809-13122001>
<SPAN
class=765525809-13122001>Regards
<SPAN
class=765525809-13122001>
<SPAN
class=765525809-13122001>Lee
<FONT face=Tahoma
size=2>-----Original Message-----From: Burton, Laura L.
[mailto:BurtonL_at_prismplus.com]Sent: Thursday, December 13, 2001
6:10 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: SqlLoader
<SPAN
class=664035505-13122001>Thank you for your reply. The user does have
DBA rights and also owns the table that is being referenced. If it was a
table rights issue I would think I would have gotten 'table or view does not
exist' message. I don't think it is even getting connected to the
database. <FONT
<FONT face=Tahoma
size=2>-----Original Message-----From: Jeff Cox
[mailto:jeffcox_at_usa.com]Sent: Wednesday, December 12, 2001 5:30
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
SqlLoader
Laura,
The username that you are trying to use, does
this username own the table that is to be loaded, or does this username have
DBA privileges?
Even though you can connect via sqlplus
and/or svrmgr to a session, this does not mean that you will be able to
load data into any table that you desire.
HTH
Regards,
Jeff
Tempe, AZ
<BLOCKQUOTE dir=ltr
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
I have never had a problem with sqlloader before, but now when I run it I get an error 'invalid name/password' message. I can sign on svrmgr and through sqlplus with no problems. Any ideas? Thanks, <FONT face=Arial size=2>Laura
The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Received on Thu Dec 13 2001 - 05:15:06 CST
![]() |
![]() |