sql *loader 414-no columns to load for table
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?