RE: SqlLoader

Laura,
We use a particular id/passwd to load the data using sqlloader. The xx.PAR file contains the userid and password along with the connect string to connect to the database.
ex:
sqlldr parfile=path/name.PAR
name.par displays
Userid=loadit/loadpasswd_at_connect string
other commands...

Has someone changed the password or parfile if you use that method? can you run the sqlloader with a xx.PAR file and use the dba/passwd_at_connect and test the command string?
ROR mª¿ªm

>>> BurtonL_at_prismplus.com 12/13/01 09:35AM >>>
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.  

Now for my stupid question. What is Two_Task?  

Thanks,
Laura

-----Original Message-----
Sent: Thursday, December 13, 2001 4:05 AM To: Multiple recipients of list ORACLE-L

Stupid question I know but is the correct SID set ??  

and watch out for TWO_TASK !!!!!!  

Regards  

Lee

-----Original Message-----
Sent: Thursday, December 13, 2001 6:10 AM To: Multiple recipients of list ORACLE-L

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.  

Laura

-----Original Message-----
Sent: Wednesday, December 12, 2001 5:30 PM To: Multiple recipients of list ORACLE-L

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

• Original Message ----- To: Multiple <mailto:ORACLE-L_at_fatcity.com> recipients of list ORACLE-L Sent: Wednesday, December 12, 2001 3:35 PM

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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).