From BurtonL@prismplus.com Thu, 13 Dec 2001 07:21:58 -0800
From: "Burton, Laura L." <BurtonL@prismplus.com>
Date: Thu, 13 Dec 2001 07:21:58 -0800
Subject: RE: SqlLoader
Message-ID: <F001.003DBCF6.20011213063529@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain
Title: SqlLoader



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.
<SPAN 
class=840282214-13122001> 
Now 
for my stupid question.  What is Two_Task?
<SPAN 
class=840282214-13122001> 
<SPAN 
class=840282214-13122001>Thanks,
<SPAN 
class=840282214-13122001>Laura

  <FONT face=Tahoma 
  size=2>-----Original Message-----From: Robertson Lee - lerobe 
  [mailto:lerobe@acxiom.co.uk]Sent: Thursday, December 13, 2001 4:05 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  SqlLoader
  <SPAN 
  class=765525809-13122001>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: 
        <A href="mailto:BurtonL@prismplus.com" 
        title=BurtonL@prismplus.com>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 <FONT 
  size=3>The information contained in this communication 
  isconfidential, is intended only for the use of the recipientnamed 
  above, and may be legally privileged. If the reader of this message is not 
  the intended recipient, you arehereby notified that any dissemination, 
  distribution orcopying 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 computersystem.