Skip to Main Content
Forums

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!

sqlldr : infile file name with joker

849400Jun 24 2011 — edited Jun 27 2011
Hi,

I want to use the SQL*Loader with an input file which I don't know the exact name.
However, I can't use "INFILE *" because there is several files and only one is needed.

For exemple :
I've got 2 files in a folder AAA123.txt and AAA456.txt
I would like to lauch sqlldr with something like this :
AAA1*.txt or AAA1??.txt or ... ?
and it will load the file AAA123.txt

Is it possible ?

thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 25 2011
Added on Jun 24 2011
#database-key-features, #export-import-sql-loader-external-tables
1 comment
836 views