Re: storing Infile name into a column from SQL Loader

On 21 May 2004 02:23:39 -0700, rvenkat_at_gmail.com (R.Venkat) wrote:

>Hi,
> i have a requirement that i need to load data of the same format
>from different datafiles. now to distinguish between these records,i
>need to put the infile name also into a column named FILENAME in the
>target table. how do i do that?
>Thanks,
>~Venkat

Use sed or any other stream editor to add the filename as a separate column to all individual records, prior to loading the file. Or load the files in individual tables, one per file and merge them afterwards.
Sql*loader can't do this.

--
Sybrand Bakker, Senior Oracle DBA