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_at_news.dial.pipex.com>
Date: Tue, 22 Oct 2002 14:57:36 +0100
Message-ID: <3db55952$0$9442$cc9e4d1f_at_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 [Quoted] 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 - 15:57:36 CEST