Skip to Main Content

SQL & PL/SQL

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!

SQLLDR - generates error ORA-00900: invalid SQL statement

user8819407Feb 9 2010 — edited Mar 24 2010
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 :-)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 21 2010
Added on Feb 9 2010
5 comments
1,963 views