| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SqlLoader
<FONT face=Tahoma
size=2>-----Original Message-----From: Burton, Laura L.
[mailto:BurtonL_at_prismplus.com]Sent: Thursday, December 13, 2001
2:35 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: SqlLoader
Hey,
at this point nothing is stupid. The problem is probably something
'stupid' that I am or are not doing. Yes, I did try setting the
Oracle_sid parameter when I started trying to figure out what was
wrong.
<SPAN
class=840282214-13122001>
Now
for my stupid question. What is Two_Task?
<SPAN
class=840282214-13122001>
<SPAN
class=840282214-13122001>Thanks,
<SPAN
class=840282214-13122001>Laura
<FONT face=Tahoma
size=2>-----Original Message-----From: Robertson Lee - lerobe
[mailto:lerobe_at_acxiom.co.uk]Sent: Thursday, December 13, 2001
4:05 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: SqlLoader
<SPAN
class=765525809-13122001>Stupid question I know but is the correct SID set
??
<SPAN
class=765525809-13122001>
<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
color=#0000ff face=Arial size=2><SPAN
class=664035505-13122001>
<SPAN
class=664035505-13122001>
<SPAN
class=664035505-13122001>Laura
<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">
----- Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
<A href="mailto:BurtonL_at_prismplus.com"
title=BurtonL_at_prismplus.com>Burton, Laura L.
To: <A
href="mailto:ORACLE-L_at_fatcity.com" title=ORACLE-L_at_fatcity.com>Multiple
recipients of list ORACLE-L
Sent: Wednesday, December 12,
2001 3:35 PM
Subject: SqlLoader
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 <FONT
 |
 |