Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> sql loader problem
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 - 16:44:57 CDT
![]() |
![]() |