Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sqlloader with direct=true --> error

730380Feb 2 2010 — edited Feb 3 2010
Hello,
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 3 2010
Added on Feb 2 2010
3 comments
1,898 views