Re: Quick move tablespace

From: Hemant K Chitale <hemantkchitale_at_gmail.com>
Date: Wed, 6 Jan 2010 23:26:56 -0800 (PST)
Message-ID: <b2cf6fbc-4fa3-4551-906d-f941c9e5cfc1_at_j24g2000yqa.googlegroups.com>


You have to take the Tablespace Offline *before* you move the datafiles and then use an ALTER DATABASE RENAME FILE 'oldlocation' TO 'newlocation' , then bring the Tablespace Online

If you have multiple datafiles you could copy the datafiles in parallel OR you could do the

TABLESPACE OFFLINE ; copy/move single datafile ; RENAME FILE ; TABLESPACE ONLINE cyclically -- e.g. one datafile every 6 hours or every day so that you reduce the OFFLINE time to smaller windows.

Hemant K Chitale

On Jan 7, 4:18 am, "bob123" <bob..._at_gmail.com> wrote:
> Hi,
>
> I have to move a big tablespace
> with a minimum of offline time.
> So is it possible to do:
> - alter tablespace begin backup
> - cp datafiles
> - alter tablespace end backup
> - alter tablespace offline
> - recover tablespace
> - alter tablespace online
>
> Thanks for your help
Received on Thu Jan 07 2010 - 01:26:56 CST

Original text of this message