Identification of loaded files (SQL*Loader)

From: Georg Niemeyer <haggis2_at_gmx.de>
Date: Thu, 05 Dec 2002 12:50:26 +0100
Message-ID: <qceuuu8h4njf72qa6ooumql2h8j3q5ntq0_at_4ax.com>



Hi,
I've got a question concerning the SQL*Loader. I would like to load a few log-Files files , genaratet from SQL*Loader while loading into the database, into one table. So my ctl-File has several "infile"-entries. Now my question, is it possible to configure SQL*Loader in such a way, that the data records in the table have an identification from which file they're from (source-column).
The Table should look like this:

source | text


file1        |   first row of the log-File
file1        |   2nd row 
file2        |   first row of the log-File
file2        |   2nd row 
file3        |   first row of the log-File
file3        |   2nd row 

The entry fileX could also be only an ID! Any help would really be appreciated.

Thanks

Georg Received on Thu Dec 05 2002 - 12:50:26 CET

Original text of this message