sqlloader with direct=true --> error
730380Feb 2 2010 — edited Feb 3 2010Hello,
I put data in my oracle database with sqlloader and the following code:
sqlldr MY_USER/MY_PASSWORD@MY_HOST control=D:\my_data.ctl log=temp_log.txt direct=true
This is working fine so far.
Then I created a new user (MY_USER_2) for my database (this user has exactly the same rights, ..., as MY_USER).
But now, when I try to launch my sqlloader with this user, I always get the following errors.
ORA-39776:
ORA-29875:
ORA-22053:
ORA-06512:
ORA-06512:
I changed nothing, except the user (I have the same tables, ...)
After some research I found out, that this problem doesn't occur, when I do my sqlloader statement without the direct=true
But the problem is, that I really need the direct=true, because there are so many values which are stroed with the sqlloader in my oracle database.
What am I doing wrong?
Thanks for the answers.
Regards