sqlldr direct load: ORA-00942: table or view does not exist

sulakhe@gmail.com · *nix forums beginner Joined: 04 May 2006 Posts: 7

Hi,
I am trying to use sqlldr's direct=t feature, but I get the following
errors while loading.

sqlldr userid=xxx/yyy@db02 control=file.ctl direct=y

SQL*Loader-951: Error calling once/load initialization
ORA-00942: table or view does not exist

If I don't use direct=y, the sqlldr command works.
( sqlldr userid=xxx/yyy@db02 control=file.ctl ).

I have been trying to find a solution for this question on the google
groups, but I don't find anyone answering this question. I am doing
append in the control file. And the table to which I am loading is
empty.

Can someone help with this problem?
Thanks in advance..
deena

Google