From lerobe@acxiom.co.uk Thu, 13 Dec 2001 03:15:06 -0800
From: Robertson Lee - lerobe <lerobe@acxiom.co.uk>
Date: Thu, 13 Dec 2001 03:15:06 -0800
Subject: RE: SqlLoader
Message-ID: <F001.003DB9C3.20011213020526@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain
Title: SqlLoader



Stupid 
question I know but is the correct SID set ??
<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@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@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@fatcity.com" title=ORACLE-L@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 

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.