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!

external table' location

248610Mar 22 2010 — edited Mar 31 2010
Database Oracle 11g R2 on Sun

I have a common structure on a external table, which will be supplied by multiple source files.

Instead of creating multiple ext table, I have created one and wants to use this one to for all files (FILE NAME is different)

alter table tbl_nm location ('filename1.dat')
And I cannot specify all possible file names, because it failed. At one point of time there will be only one file will be available for this external table.

Is there anyother best practicies for this approach?

Thanks,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 28 2010
Added on Mar 22 2010
#data-warehousing, #warehouse-builder
8 comments
1,903 views