Re: Fast data import into oracle

[Quoted] "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.
>
>

[Quoted] 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 Wed Oct 03 2001 - 18:34:47 CEST