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 -> Limitation with SQL Loader?

Limitation with SQL Loader?

From: <bkirkbride_at_cw.net>
Date: Mon, 13 Dec 1999 21:40:33 GMT
Message-ID: <833p4g$qru$1@nnrp1.deja.com>


Is it possible to load records from within the SQL*Loader control file with fixed length records?

In other words, is this valid:

INFILE * "fix 85"

The reason I ask is because SQL*Loader is complaining that the physical record in the file exceeds 65536 bytes. This shouldn't even be possible because I've already told it that all records are 85 bytes, right? BTW this control file works when separate from the data. I've tried placing the data immediately after the BEGINDATA keyword, on the next line, after a space...

Thanks in advance

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 13 1999 - 15:40:33 CST

Original text of this message

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