Re: Fast data import into oracle

Thanks,

LOL stupid me the obvious,

Off to read the book again.

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:9pg09c$i6ufr$2_at_ID-62141.news.dfncis.de...
>
> "Steve Allan" <steve.allan_at_blueyonder.co.uk> wrote in message
> news:ScBu7.44201$iG3.2876021_at_news1.cableinet.net...
> > Hi,
> >
> > Currently I am using two methods of importing data into an Oracle DB (on
> > Unix)
> >
> > 1. OCI (API) through a c++ program
> >
> > 2. SQLLoader on unix box using comma separated files.
> >
> > I have been told that there is another faster standard way of importing
> > separated files into oracle from unix.
> >
> > Direct load ?????
> >
> > Can anyone point me in the right direction.
> >
> > Many thanks in advance
> >
> > Steve
> >
> >
> > --
> > No computer components were harmed during the creation of this post,
> > however several billion electrons were abused to ensure its safe
delivery.
> >
> >
>
> Direct load is just using sqlloader with the parameter direct=y
> For further details see the Oracle Server Utilities manual.
>
> Hth,
>
> Sybrand Bakker, Senior Oracle DBA
>
>
>
Received on Thu Oct 04 2001 - 15:11:21 CEST