Re: SQL*Load file format question
From: RSpencer <rspencer_at_aol.com>
Date: 1995/12/01
Message-ID: <49n5f2$la6_at_newsbf02.news.aol.com>#1/1
Date: 1995/12/01
Message-ID: <49n5f2$la6_at_newsbf02.news.aol.com>#1/1
According to the Oracle Utilities manual the answer to this depends on a couple of things. If you're using version 1.0 of SQL*Loader then you could use the following:
INFILE 'mydata.dat' FIXED n
Where n is your record length.
If you're using version 1.1 and above you can accomplish the same thing with a file processing options string. This string is system dependent. The string contents can be found in the Oracle Installation and User's Guide for you system. In this case you would use the following:
INFILE 'mydata.dat' "file processing options string" Received on Fri Dec 01 1995 - 00:00:00 CET