Re: Processing batches, requesting comments with sqlldr and preapred UPDATes.

Home -> Community -> Usenet -> c.d.o.misc -> Re: Processing batches, requesting comments with sqlldr and preapred UPDATes.

From: Brian Tkatch <N/A>
Date: Tue, 23 Oct 2007 16:30:00 -0400
Message-ID: <87msh3d97f7d89thqgu8nb1k788n9110uk@4ax.com>

On Tue, 23 Oct 2007 12:02:47 -0500, Brian Peasland <dba_at_nospam.peasland.net> wrote:

>Have you looked at External Tables? This is available in Oracle 9i.
>External Tables use the same SQL*Loader engine so you get the same
>speed. And you can do a simple INSERT..SELECT to read the External
>Table's contents and populate your (internal) table.

The files to be loaded are usually in the thousands. If i just read it correctly, the files must be mentioned in the DDL statement itself.That would not be possible, especially since the list files is still growing, and we could not get a change like that into production quickly enough.

Or is the filelist variable?

B. Received on Tue Oct 23 2007 - 15:30:00 CDT