SQLLDR - generates error ORA-00900: invalid SQL statement
Hi,
I'm trying to import data from a csv file using SQLLDR but got problems. When I run the SQLLDR as below
sqlldr userid=system/pwd@orcl, control="C:\Import_Oracle_Data\control_file.ctl", log="C:\Import_Oracle_Data\log.log"
I got error message: ORA-00900: invalid SQL statement.
My control file looks as follows
load data infile 'C:\Import_Oracle_Data\AUTHORS.DAT'
append into table AUTHOR
fields terminated by ';'
-- Without the TRAILING NULLCOLS clause, an error would be generated, due to missing data.
trailing nullcols
-- How to parse the data
+(ID, NAME, DATE_OF_BIRTH)+
Pls, advice and even better tell me what is wrong :-)