Re: 10g External Table Location Parameter
- From: "Greg Rahn" <greg@xxxxxxxxxxxxxxxxxx>
- To: cjnewman@xxxxxxxxxxxxx
- Date: Thu, 6 Nov 2008 21:53:26 -0800
You can not use wildcards, but you can list multiple files
LOCATION (
'a.txt',
'b.txt',
'c.txt',
...
)
On Wed, Nov 5, 2008 at 1:53 PM, Newman, Christopher
<cjnewman@xxxxxxxxxxxxx> wrote:
> Greetings all,
>
> Does anyone know if the location parameter when creating an external
> table can be wildcarded? Our scenario is we want to have all the .txt
> files in the directory added to the table at once. I'm been trying many
> different formats, but no joy so far. It takes the string as a literal
> whether I'm using OS or Oracle variables.
>
> LOCATION ('*.txt') <-- this is where I want it to grab all the .txt
> files...
--
Regards,
Greg Rahn
http://structureddata.org
--
//www.freelists.org/webpage/oracle-l
Other related posts:
