Re: Help! INGRES to ORACLE

dleclair_at_fox.nstn.ca wrote:
>
> Hi!
> I Hope someone out there can help me!
> I'm currently managing a project where we are converting a server
> application which used to run against an Ingres DB to make it run against
> an ORACLE DB (V7.3).
>
> Our original application made extensive use of the Ingres "COPY" command
> (i..e not to be confused with the "COPY OUT/IN" commands!) to copy the
> contents of ascii files into tables. These tables are not indexed in any
> way, have no triggers, no constraints, etc.
>
> In converting our code to operate properly with the new DB, we had to
> change all references to the Ingres "COPY" command because of its
> inexistence within the ORACLE RDBMS SQL syntax.
>
> We were told that ORACLE'S version of the "COPY" command was SQL*LOADER.
> We have sinced modified our code to make use of SQL*LOADER and the
> results are far from being impressive!!!!! (e.g. where the "COPY" command
> took 1 second to load 20 records, SQL*LOADER takes 10 secs.)
>
> Has anyone out there used the SQL*LOADER command and obtained reasonable
> results? Is there another command which we could used to obtain a better
> response time?
>
> Answers to any of these questions or additional comments would be more
> than welcomed!A SQL*Loader job can be parallelized and perform Direct Path loads which
bypass writes to the buffer cache instead writing directly to disk. Very fast. Check out the details in your Utilities manual.

-- 
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.