Re: External tables change directory

From: rjamya <rjamya_at_gmail.com>
Date: Fri, 8 Dec 2006 06:51:36 -0500
Message-ID: <9177895d0612080351x1d49ca91s5f7f376361c9503d@mail.gmail.com>

after changing directory, did you do "alter table ... location ('...')" to specify the new directory and datafile?

Raj

On 12/7/06, Ranko Mosic <ranko.mosic_at_gmail.com> wrote:
> Hi List,
> Oracle is 10.2.0.2
> Is it possible to change external table directory.
> We tried 'create or replace directory 'new_path' but are getting
> KUP11010

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 08 2006 - 05:51:36 CST