Re: SQL Loader automation

From: John F. Keaveney <johnkeaveney_at_targusinfo.com>
Date: Tue, 23 Feb 1999 09:44:01 -0800
Message-ID: <7aupce$l7j$1@news1-alterdial.uu.net>

I don't think I could write an OCI application with the performance of SQL Loader. OCI, as far as I know, can only perform transactional inserts. Even using host arrays I don't think it will touch the performance of the SQL Loader using direct path.

Thanks,

John
jacob wrote in message <01be5f0b$04e52e40$ec1b1dac_at_ut9811251830>...
>write your own sqlldr using OCI! (or better yet, use the DBI extension for
>perl)
>You kill two birds with one stone-> perl will easily parse the text files
> ->DBI will shove it up
>oracles tables
Received on Tue Feb 23 1999 - 11:44:01 CST