Re: sql loader problem

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:12:50 CDT