Re: 10g External Table Location Parameter

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_at_uillinois.edu> 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
--
http://www.freelists.org/webpage/oracle-l