Home » RDBMS Server » Server Utilities » Rea Help On SQlloader
Rea Help On SQlloader [message #71229] Thu, 26 September 2002 23:37 Go to next message
Naveen
Messages: 75
Registered: June 2001
Member
I am very new to sqlloader i am not able to get it executed properly.Below is my control file

LOAD DATA
INFILE 'D:ORACLEORA90BINXXX.TXT'
insert
INTO TABLE T
fields terminated by '#'
(a position(01:01) , b position(03:03))

xxx.txt
1,1,
2,2,
3,3,

Error i am gettin gis
SQL*Loader-350: Syntax error at line 6.
Illegal combination of non-alphanumeric characters
(a position(01:01) , b position(03:03))
Re: Rea Help On SQlloader [message #71230 is a reply to message #71229] Fri, 27 September 2002 04:02 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
your fields are terminated by ',' comma.
not by '#' hash
Previous Topic: Re: FREE OCP PAPERS
Next Topic: Re: SQL *Loader - 524: partial record found at the end of datafile (demog.ctl)
Goto Forum:
  


Current Time: Mon Apr 29 02:31:08 CDT 2024