Re: Need with with SQL Loader

From: Ranga Chakravarthi <ranga_at_nospam.cfl.rr.com>
Date: Fri, 09 Feb 2001 03:20:10 GMT
Message-ID: <KlJg6.90687$Tl3.17629538@typhoon.tampabay.rr.com>

Chuck,

There are example files that come with the database. I don't remember the exact location of these files. You can find it a) in unix: find $ORACLE_HOME -name "utlcase*.ctl" -print b) in windows: start menu->Find->Files or folders utlcase*.ctl

Ranga Chakravarthi OCP

"Chuck " <rhugga_at_yahoo.com> wrote in message news:3a834bdc.207189642_at_news.pacbell.net...
>
> I am trying to use sqlldr for the first time and am having problems
> figuring out how to write the control file.
>
> I have a very basic data file consisting of column elements separated
> by commas (Your standard csv file) Some columns are null, which look
> like (',,') in the file.
>
> I want to load this into an empty table. The columns/fields match up
> perfectly.
>
> If anyone can assist me or share a control file that does something
> similiar I would greatly appreciate it.
>
> Thanks,
> CC
>
Received on Thu Feb 08 2001 - 21:20:10 CST