Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sql loader problem

sql loader problem

From: Brian Howard <bh_at_creditwatch-inc.com>
Date: Tue, 28 Sep 1999 21:44:57 GMT
Message-ID: <37F133DA.3DFF1270@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 - 16:44:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US