Re: sql loader problem

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,

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 Tue Sep 28 1999 - 17:53:15 CDT