RE: 10g External Table Location Parameter
- From: "Newman, Christopher" <cjnewman@xxxxxxxxxxxxx>
- To: "Newman, Christopher" <cjnewman@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 5 Nov 2008 15:58:47 -0600
Replying to myself in bad form, while I am curious if this can be done,
we solved this by concatting all of the individuals into one and loading
that.
Cheers- Chris
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Newman, Christopher
Sent: Wednesday, November 05, 2008 3:54 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: 10g External Table Location Parameter
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
