Re: Automating data loading into Oracle

I did something similar before, try to delegate as much as possible to Oracle SQL*Loader, and write as less code as you can.

SQL*Loader is a great tool to bulk load data into Oracle database, and it helps you to migrate data from file system or other database systems.

Comment on Re: Automating data loading into Oracle

Replies are listed 'Best First'.
Re^2: Automating data loading into Oracle by punkish (Priest) on Oct 24, 2005 at 22:15 UTC
I will try, but methinks that a lot of "transformation" needs to be done in the interim step. Not all data arrive in a consistent format -- some a text files, others may be .dbf, still others might be other db tables (Oracle or SQL Server). All these factors might limit how much I can use SQLLoader -- when small people start casting long shadows, it is time to go to bed*	[reply]