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@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 >>> [EMAIL PROTECTED] 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:[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
