SQLLoader and ORA-04043

I had to import almost half of billion rows in one Oracle table and for that I wrote a small SQLLoader script (below):

"load data infile * append into table "usermonth....."

And I received the following error message

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

After one hour of despair and I realized by pure luck that you need to provide the name of the table with upper case, otherwise the utility is not able to find it. Quite strange, but at least I’m happy that now it works.

Show Comments

Hide Comments

Comments are closed.