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: Control file for SQL*Loader

Re: Control file for SQL*Loader

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 3 Mar 2006 07:19:22 -0800
Message-ID: <1141399162.128352.10510@z34g2000cwc.googlegroups.com>


Freier, Mr Cadot pointed you to the documentation. I just want to point out that sqlldr works with two types of input files: delimited where you use a delimiter like a comma, tab, or pipe to separate the data values or fixed format data where the values are always in specific column positions. Your data should be in one of these two formats for use with sqlldr.

>From your post it would appear the data is fixed format which is case 2
in the referenced material.

HTH -- Mark D Powell -- Received on Fri Mar 03 2006 - 09:19:22 CST

Original text of this message

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