SQL*Loader Question

From: Larry N. Singh <lns_at_vis.toronto.edu>
Date: 1998/02/27
Message-ID: <1998Feb26.200454.798@jarvis.cs.toronto.edu>#1/1

Hi,

I'm trying to load a flat text file into an Oracle Database ( 7.2.2 ). The file contains several records each of a fixed length ( 100 bytes long ). In every example I've seen of using SQL Loader, records were delimited by end- -line. So, when I run SQL*Loader only 1 record is inserted into the database. I was wondering if there was a way of specifying the record length in bytes. I've tried specifying RECSIZE=100, but then it can't open the file for some reason.

Thanks very much in advance for any help.

Larry. Received on Fri Feb 27 1998 - 00:00:00 CST