-
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
-
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
-
Yeahp.
Docs are good :)
Search APPEND
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|