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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Sqlldr problem with variable records

Re: Sqlldr problem with variable records

From: Ed Prochak <ed.prochak_at_magicinterface.com>
Date: Mon, 07 Oct 2002 18:27:29 GMT
Message-ID: <3DA1FF20.5CE39B09@magicinterface.com>


Burkhard Holl wrote:
>
> Hello,
>
> we are running version 8.0.5 under Tru64 and having a problem with
> "sqlldr", when trying to load variable records.
> The control file contains the INFILE options "var" and each record has
> the leading 5 characters, indicating the record length. The table fields
> are a mixture of "char" and "raw". The "sqlldr" program aborts with
> segmentation failure. However, using the same control and input file and
> running sqlldr version 8.1.7, also under Tru64, the table is loaded with
> any error messages. Besides from upgrading to 8.0.5, are there any other
> solutions?
>
> Best regards
>
> B. Holl

Does changing the input file help at all? (e.g., split the input file into 3 files each with 1/3 of the original records).

-- 
Edward J. Prochak   --- Magic Interface, Ltd.
Ofc: 440-498-3700   --- 7295 Popham Place, Solon, OH 44139
on the web at       --- http://www.magicinterface.com
email: ed.prochak_at_magicinterface.com
Received on Mon Oct 07 2002 - 13:27:29 CDT

Original text of this message

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