Re: Using DBMS_METADATA/DBMS_REDFINITION to move all objects to another TS
From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Thu, 20 Jun 2013 14:30:13 -0500 (CDT)
Message-ID: <395a241a3c5f7f9df647d4de236cf7da.squirrel_at_society.servebeer.com>
Andrew writes:
Date: Thu, 20 Jun 2013 14:30:13 -0500 (CDT)
Message-ID: <395a241a3c5f7f9df647d4de236cf7da.squirrel_at_society.servebeer.com>
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-lReceived on Thu Jun 20 2013 - 21:30:13 CEST