SQL*Loader problem - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: SQL*Loader problem

  1. #11
    Try the command with everything
    C:\>sqlldr scott/tiger filename.ctl ..... etc
    or
    C:\>sqlldr userid=scott/tiger control=filename.ctl ..... etc
    I'm supposing you can do a
    C:\>sqlplus scott/tiger
    If you can't try
    C:\>sqlplus scott/tiger@alias ... the same for sqlldr
    Ramon Caballero, DBA, rcaballe@yahoo.com

  2. #12
    Join Date
    Oct 2000
    Posts
    211
    thanks ramon,
    your last suggestion worked, though i dont see how it is different from others i have been trying.
    Anyway i am up with another problem and
    the error now says "for INSERT option, table must be empty. error on table scott.dept"
    I guess i need to go through the documentation more thoroughly.
    manjunath

  3. #13
    Yeahp.
    Docs are good :)
    Search APPEND
    Ramon Caballero, DBA, rcaballe@yahoo.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width