Re: Using DBMS_METADATA/DBMS_REDFINITION to move all objects to another TS
- From: "Rich Jesse" <rjoralist2@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 20 Jun 2013 14:30:13 -0500 (CDT)
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
Other related posts:
