RE: SqlLoader

Laura,

One idea, select username and status from dba_user. I would guess that should work, but ...

Another thought, you say you can connect via sqlplus. Is your sqlplus connection of the form user/password_at_sid or just user/password? If it is the latter, your environment vairable ORACLE_HOME (echo $ORACLE_HOME on Unix) decides what db to connect to and could be pointing you to a different db.

HTH Stephen Andert

>>> BurtonL_at_prismplus.com 12/12/01 23:54 PM >>>
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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Andert
  INET: stephenandert_at_firsthealth.com

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