Re: 10g External Table Location Parameter

From: Greg Rahn <>
Date: Thu, 6 Nov 2008 21:53:26 -0800
Message-ID: <>

You can not use wildcards, but you can list multiple files LOCATION (



On Wed, Nov 5, 2008 at 1:53 PM, Newman, Christopher <> 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...

Greg Rahn
Received on Thu Nov 06 2008 - 23:53:26 CST

Original text of this message