RE: SqlLoader

From: Burton, Laura L. <BurtonL_at_prismplus.com>
Date: Wed, 12 Dec 2001 22:34:17 -0800
Message-ID: <F001.003DB7E7.20011212221017@fatcity.com>

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: 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 Received on Thu Dec 13 2001 - 00:34:17 CST