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 13:42:07 -0500
Message-ID: <CAJvnOJZ8jq9e+WeZPjT8LvjK8iqL+9P+EzbXSOn9aPkxJhAMbA_at_mail.gmail.com>



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... Not sure about a downtime requirement for renaming indexes, but if necessary it would be very short.

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

>
>
> --
> 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 - 20:42:07 CEST

Original text of this message