Hi all,
I am using a Sqlloader for loading the data from a dat file to a table Customer_tmp. I have using the perl scirpt and doing this job from last few week. its working fine my env is oracle 8i and OS is Linux. Recently we created a oracle 9i on another linux box where this sqlloader is not working. i tested the same againg in Oracle 8i box its working fine.
the data in my dat files is as follows
1249922{,|[email protected]{,|!09/05/00{,|!LE{,|!marc{,|!ANÉ{,|! {,|!N{,|!0{,|!228{,|!0{,|!INT{,|!0{,|!0{,|!1000001{,|!BLSTH
where {,|! is the Delimiter
and my .ctl file contains as follows
LOAD DATA
INFILE 'test3.dat'
TRUNCATE INTO TABLE customertmp
FIELDS TERMINATED BY "{,|!"
(OID, EMAIL, REGDATE DATE 'mm/dd/yy', REGTYPE, FNAME, LNAME, GENDER,
UPLOADED, DOLLERS, WEEKSSINCEREGISTRATION, AMOUNTSPENT,
REGPATH, FREEDOLLERS, DOLLERSEXPIRATION,CATINID,
CATIN_NAME )
i am getting the following error
Column not found before end of logical record (use TRAILING NULLCOLS)
i can use trailing nullcols after Terminated By "{,|!" because some of the fields in my data are ' '. Even if used that i will giving that in valid number for AmountSpent.
and from perl iam using the following command to execute sqlldr
if (system("sqlldr userid=$dbuser/$dbpass\@$dbname control=$ctlfile log=$logfile bad=$badfile direct=true") != 0) {
die "Running sqlldr failed!\n";
}
Please can any one help me..........................
Thanks in Advance
sambadamerla
Enter your message below
Sign in or Join us (it's free).