SQL*Load file format question
From: John Moriarty <jmm_at_wang.com>
Date: 1995/11/30
Message-ID: <49lars$9d1_at_elf5.wang.com>#1/1
Date: 1995/11/30
Message-ID: <49lars$9d1_at_elf5.wang.com>#1/1
I am attempting to load a fixed format file into an Oracle database using the SQL*Loader under HPUX. The problem is the rows are not terminated by carriage returns. It's a single file with one very large physical line in it. SQL*Load doesn't know where the end of the record is and subsequently reports that row is greater than 64K and terminates.
Is there a way to specify the total length of the record?
thanks for any info,
John Moriarty john.moriarty_at_wang.comReceived on Thu Nov 30 1995 - 00:00:00 CET