Re: Using DBMS_METADATA/DBMS_REDFINITION to move all objects to another TS
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: rjoralist2@xxxxxxxxxxxxxxxxxxxxx
- Date: Thu, 20 Jun 2013 14:45:51 -0500
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@xxxxxxxxxxxxxxxxxxxxx> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
--
//www.freelists.org/webpage/oracle-l
Other related posts:
