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:
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