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

sulakhe_at_gmail.com wrote:
> I am trying to use sqlldr's direct=t featuer, but I get the following
> errors while loading.
>
> sqlldr userid=xxx/yyy_at_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_at_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.

You do not even tell us which version of what you are using.

Could it be that you hit Bug 2341550 described in Metalink note 208750.1?

Yours,
Laurenz Albe Received on Thu May 04 2006 - 11:35:55 CEST