10g External Table Location Parameter

From: Newman, Christopher <cjnewman_at_uillinois.edu>
Date: Wed, 5 Nov 2008 15:53:50 -0600
Message-ID: <565F609E6D736D439837F1A1A797F34101C6EF26@ADMINMAIL1.ui.uillinois.edu>

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...

Thanks- Chris

Received on Wed Nov 05 2008 - 15:53:50 CST

Original text of this message