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 12:49:34 -0500
Message-ID: <CAJvnOJbz8ZfFF7URdYOEOa8Tw6WDLxe7V-Y_Nvwy1nNpkqsumg_at_mail.gmail.com>

I expect you answered your own question, it probably needs to be done online. You can also automate the steps in dbms_redefintion, it took me some time but I was able to write a stored procedure to do it for an entire tablespace. One hint is to turn off the pretty option.

On Thu, Jun 20, 2013 at 12:02 PM, Powell, Mark <mark.powell2_at_hp.com> wrote:

> Why not just issue Alter table move t_a tablespace new_t followed by alter
> index i_1 rebuild tablespace new_1 ? This would be good for any tables
> without long and long raw columns though this would take a down window.
> Otherwise using dbms_redefiniton for online moves should work but it is a
> lot more work.
> <snip?
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> 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 - 19:49:34 CEST