Loading a filename using SQL Loader?

From: Ian Atkinson <ian_david_at_my-deja.com>
Date: Mon, 02 Aug 1999 10:58:42 GMT
Message-ID: <7o3tl0$d9a$1_at_nnrp1.deja.com>

Is it possible to load a filename with it's associated data using SQL Loader?

I am using Perl to scan a directory and create many "INFILE filename BADFILE filename DISCARDFILE filename" statements which are inserted at the top of the control file.

I guess if the files were loaded one at a time (calling the control file for each data file) it would be possible to pass the filename as a variable to the control file, but with many files being continuosly loaded this would have a large impact on performance.

Any suggestions?

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Aug 02 1999 - 12:58:42 CEST

Original text of this message