Try the command with everything
C:\>sqlldr scott/tiger filename.ctl ..... etc
C:\>sqlldr userid=scott/tiger control=filename.ctl ..... etc
I'm supposing you can do a
If you can't try
C:\>sqlplus scott/tiger@alias ... the same for sqlldr
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.