Oracle Data Replication versus FTP and sqlldr

From: <una_toroc_at_my-deja.com>
Date: Wed, 04 Aug 1999 20:18:14 GMT
Message-ID: <7oa75q$us6$1@nnrp1.deja.com>

Hi,

I have a question about the relative speed of using either Oracle data replication and ftp'ing of a ASCII flat file and running sqlldr on the same to insert my data into an Oracle database.

All the platforms are Sun Solaris v2.6. The database version is Oracle 8i Enterprise Edition. The data volume is in the range of around 100M. The process has to be repeated hourly.

If anyone has any experience with this kind of problem, I'll appreciate any help you can provide me.

Thanks.

Una.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Aug 04 1999 - 15:18:14 CDT