Skip to Main Content

Database Software

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 414-no columns to load for table

user618849Mar 4 2010 — edited Mar 5 2010
newbie question
i create the control file:

LOAD DATA
APPEND INTO TABLE mtl_system_items_load_5
(
organization_id FILLER CHAR
TERMINATED BY "," ENCLOSED BY '"',
last_update_date FILLER CHAR
TERMINATED BY "," ENCLOSED BY '"',
last_updated_by FILLER CHAR
TERMINATED BY "," ENCLOSED BY '"',
creation_date FILLER CHAR
TERMINATED BY "," ENCLOSED BY '"',
created_by FILLER CHAR
TERMINATED BY "," ENCLOSED BY '"',
last_update_login FILLER CHAR
TERMINATED BY "," ENCLOSED BY '"',
description FILLER CHAR
TERMINATED BY "," ENCLOSED BY '"',
segment1 FILLER CHAR
TERMINATED BY "," ENCLOSED BY '"',
process_flag FILLER CHAR
TERMINATED BY "," ENCLOSED BY '"',
transaction_type FILLER CHAR
TERMINATED BY "," ENCLOSED BY '"',
set_process_id FILLER CHAR
TERMINATED BY "," ENCLOSED BY '"'
)


items file

"204","sys","204","sys","111","234","tes","98t","111","cre","000"


i use the folloiwng command to run

sqlldr inv/inv@xxx control=control.txt log=logdata.txt data=items.txt

i get the following

SQL*LOADER-414: no columns to load for table..mtl_system_items_load_5
i have the table built in the database.


what does this mean?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 2 2010
Added on Mar 4 2010
1 comment
1,979 views