Re: SQLLDR timestamp question

David wrote:
>
> Hi, I have a textfile containing a list of fully qualified filenames
> that I am successfully using as a source file to load the files into
> an Oracle database with SQLLDR as BLOBs. Although this textfile
> contains the fully qualified filenames, it does not contain the
> associated file creation timestamp.
>
> I need to populate the file creation timestamp into the database in
> addition to the file. Can SQLLDR acquire this information for me ? (I
> have a workaround at the moment but just need to canvas opinion as to
> whether the workaround is really necessary).
> Thank you
> David

I don't think SQLLDR can get it natively. Probably a little bit of awk/sed etc needed to make it into a column in the input stream

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."