Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Loader fastest way to load data?
Thanks. Is there an API one can use to get the same (direct path) data load
performance as SQL*Loader?
Dale & Denise <dzerber_at_home.com> wrote in message
news:hB3o4.17711$2C1.391801_at_news1.rdc1.il.home.com...
> Yes,
>
> Sql*Loader is the fastest method of simply dumping data into a Oracle
> Database. However in most cases there is more to data loading than simply
> dumping data into a table. This however is dependant of the type of
> application the data load is supporting. Some descision support type
systems
> require data extraction, data cleansing, data transformation, data
> transportation, data staging and the final step is data loading. In this
> case SQL Loader only does the loading portion well. I do know of another
> tool that may suite your needs called Optiload. This Tool is designed to
> move data from the MVS world to either an Oracle databse on Soaris or a
DB2
> database on RS6000. for more information Go to www.dewpointinc.com and
send
> a request.
Received on Wed Feb 09 2000 - 08:32:00 CST