I am having trouble getting a control file to insert rows in a table. (Error message SQL*Loader-601:
I know this sounds weird but I am going to explain this as easy as possible.
The error I am getting is:
SQL*Loader-601: For INSERT option, table must be empty. Error on table PROJ_INS
1. I have a excel file that has data that needs to go into a table.
2. Made a (Loader.bat) file to run the control file.
sqlldr fiveyr/**********@prod control=c:/minorload/fy2013.ctl
3. Made the control file called (fy2013.ctl) that has the data in the file.
sytax I used:
load data
infile *
into table proj_ins
fields terminated by ',' optionally enclosed by '"'
0