I am running Oracle 10g on a Sun V490/Solaris 10 platform. When I attempt to run sqlldr from the command line (see below for the top of the .ctl file) I get the following error;

SQL*Loader-941: Error during describe of table VD_CLAIM
ORA-04043: object VD_CLAIM does not exist

I am logging into sqlldr as SYS, connecting as sysdba since the owner of the schema/table gets booted out as "invalid user/password". This is odd in that the user can log into the Enterprise Manager and isqlplus interfaces and perform all appropriate actions.

I have looked up the error (04043) and it appears to be tied to privileges; but SYS has full privileges on the table VD_CLAIM.


LOAD DATA
INFILE '/export/medic/tape4/vendor/utd_clm.dat'
INSERT
INTO TABLE VD_CLAIM

thanks for any help,

Orwreckal