Re: Using DBMS_METADATA/DBMS_REDFINITION to move all objects to another TS

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Thu, 20 Jun 2013 14:45:51 -0500
Message-ID: <CAJvnOJbEDF0eRTUOQrNMG_rznvyikHRLt+F9iLsQ0pL9406zUg_at_mail.gmail.com>

Oh, I misunderstood the problem. To change the tablespace: th := dbms_metadata.add_transform(h,'MODIFY');

dbms_metadata.set_remap_param(th,'REMAP_TABLESPACE',tablespace_name,new_tablespace);

dbms_metadata.set_remap_param(th,'REMAP_TABLESPACE',ind_tablespace,new_ind_tablespace);

On Thu, Jun 20, 2013 at 2:30 PM, Rich Jesse < rjoralist2_at_society.servebeer.com> wrote:

> Andrew writes:
>
> > With regard to the index naming, is it possible to do the redef, then
> > rename the indexes? It might take some thought, but something along the
> > lines of generating a name on the redef, then naming the index back when
> > complete...
>
> Nope -- the redef would create the new ones in the original TS, which would
> defeat the purpose of the move.
>
> It seems like it's not just me that thinks there could be some improvements
> in the redef for v12... :)
>
> Rich
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'


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

Received on Thu Jun 20 2013 - 21:45:51 CEST