Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to select a data file from a folder for Sqlldr at runtime

MUmarAliApr 8 2015 — edited Apr 30 2015

Dear All

I am using Database 11g Rel.2 client on windows 2012 Server with Database 10g Rel.2 on another server.

I am getting pipe-sign separated text files from a third party software in a specific folder on my client machine.

That 3rd party software exports data files after every 30 minutes with naming convention as " Filename-Date(YYYYMMDD)_Time(HH24MI) " like this:

testdata-20150408_0935

testdata-20150408_0905

testdata-20150408_0835

....

and so on...

I've tested and successfully imported data using Sqlldr from my client machine into database, but only with a specific name like " testdata ".

I don't know how to import the last generated file with latest Date Time stamp.

Can you people give me a solution to handle this situation?

Thanks in advance.

This post has been answered by Solomon Yakobson on Apr 18 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 28 2015

Added on Apr 8 2015

#database-key-features, #export-import-sql-loader-external-tables

19 comments

4,348 views