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!