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: Oracle 8i: Importing CSV Files

Re: Oracle 8i: Importing CSV Files

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 22 Oct 2002 14:57:36 +0100
Message-ID: <3db55952$0$9442$cc9e4d1f@news.dial.pipex.com>


"Andy Snodgrass" <andy.snodgrass_at_telecaXXX.com> wrote in message news:ap3h7p$j8o$1_at_reader0.news.uk.quza.net...
> Hi,
>
> I have a large (100s of 1000s of lines long) CSV file that I want to
import
> into an Oracle table. I am using Oracle 8i.
>
> * What are my options?
>
> * I have heard of a tool called SQL*Loader is this provided as standard
with
> Oracle 8i?

sql*loader is indeed probably your best bet. If you take a look at the utilities manual you will find it described with examples.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Tue Oct 22 2002 - 08:57:36 CDT

Original text of this message

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