Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 8i: Importing CSV Files
"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
![]() |
![]() |