Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL*Loader-941: Error during describe of table

DevguyMar 21 2011 — edited Mar 21 2011
I am getting the below error

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

Description of the table from SQL:

SQL> desc imdb_top_250;
Name Null? Type
----------------------------------------- -------- ----------------------------

RANK NUMBER(3)
RATING NUMBER(2,1)
TITLE VARCHAR2(200)
VOTES NUMBER(12)


Control file description:

load data
infile "imdb_top_250.csv" badfile "imdb_top_250.bad" discardfile "imdb_top_250.dsc"
insert into table IMDB_TOP_250
fields terminated by ','trailing nullcols
(RANK,
RATING,
TITLE,
VOTES
)


sqlldr scott/tiger@orcl control=imdb_top_250.ctl log=imdb_top_250

Any suggestions are highly welcomed
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 18 2011
Added on Mar 21 2011
19 comments
19,901 views