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.
INTO TABLE VD_CLAIM
Thank you. Below is the way I access sqlldr; this particular login works. However my other user MFAD cannot login as it gets the ora 04043 error "invalid user/password". This is very odd as this particular user can login into the enterprise manager and isqlplus interfaces.
>sqlldr \' sys/xxxxx AS SYSDBA \'
The system responds with
I enter the path/name of the control file and it begins to run and then ends with the following error;
SQL*Loader-941: Error during describe of table MFAD.VD_LOCKIN
ORA-04043: object MFAD.VD_LOCKIN does not exist
MFAD is the user/schema name that works everywhere but sqlldr.