Re: External Table Question
Date: Wed, 9 Jan 2008 08:33:02 -0800 (PST)
On Jan 8, 8:15 pm, "ame..._at_iwc.net" <ame..._at_iwc.net> wrote:
> I love these external tables. It really gets rid of the old
> Anyhow, is there a way to create an external table where the filename
> is dynamic? Basically the filename changes a couple of times during
> the process.......
> Not sure if this can be done short of re-creating the table, but I
> thought I'd ask.....
> Regards & Thanks!
Try ALTER <table> LOCATION ('<file1>', '<file2>')Received on Wed Jan 09 2008 - 10:33:02 CST