Re: sql loader problem

Although the error message complains about the control file, i'll be tempted to look at your CSV or text file you are trying to load. Make sure that any returns or line feeds haven't been accidently stripped out. This is possible when FTP'ing in the wrong format.

Mark

Brian Howard <bh_at_creditwatch-inc.com> wrote in message news:37F143DD.1D47490F_at_creditwatch-inc.com...
> the control file looks like the following:
>
> LOAD DATA
> REPLACE
> INTO TABLE QUANAYA.LOADER
> FIELDS TERMINATED BY " "
> TRAILING NULLCOLS
> (
> BILL_NR CHAR,
> CURR_AMT_DUE DECIMAL EXTERNAL,
> CUST_NM CHAR,
> DELINQ_AMT_DUE DECIMAL EXTERNAL,
> ST_CD CHAR,
> TN_EFF_DT DATE "YYMMDD"
> )
>
> Jeff Hunter wrote:
>
> > Look at your control file and make sure you're not specifying the data
file
> > wrong...
> >
> > Otherwise, post your control file as well...
> >
> > Brian Howard wrote in message <37F133DA.3DFF1270_at_creditwatch-inc.com>...
> > >I need help. I am trying to load some data via sql loader into an
oracle
> > >7.0 database on A/UX.
> > >
> > >When using the following command
> > >
> > >sqlldr userid=quanaya/qt1323 control=telco.ctl log=log.log bad=bad.bad
> > >data=091399.txt discard=discard.dcs
> > >
> > >I am getting the following:
> > >
> > >SQL Loader-510: Physical record in data file (telco.ctl) is longer than
> > >the maximum (65336)
> > >
> > >This is the control file name not the data file name. The book says
that
> > >it will attempt to use the control file if it cannot recognize the data
> > >file; however, it is there and I can't get it to work. Is my syntax
> > >wrong?
> > >
> > >I have also tried
> > >
> > >sqlldr userid=quanaya/qt1323 control=telco.ctl log=log.log bad=bad.bad
> > >data='091399.txt' discard=discard.dcs
> > >
> > >and
> > >
> > >
> > >sqlldr userid=quanaya/qt1323 control=telco.ctl log=log.log bad=bad.bad
> > >data="091399.txt" discard=discard.dcs
> > >
> > >and many other combos but it gets the same message. Any suggestions?
> > >
>
Received on Wed Sep 29 1999 - 08:25:47 CDT