Re: Quick move tablespace
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Wed, 6 Jan 2010 13:00:12 -0800 (PST)
Message-ID: <87b4ae4b-cd34-472d-9c7d-25b95632cb4a_at_r24g2000yqd.googlegroups.com>
On Jan 6, 3:18 pm, "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
Date: Wed, 6 Jan 2010 13:00:12 -0800 (PST)
Message-ID: <87b4ae4b-cd34-472d-9c7d-25b95632cb4a_at_r24g2000yqd.googlegroups.com>
On Jan 6, 3:18 pm, "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
To move a tablespace you would actually move the datafiles under the tablespace. To do that you take the tablespace offline, Copy or move the files at the OS level, rename the files in Oracle to reflect the new OS names, and bring the tablespace back online. Now in the case of a copy at the OS level remove the old datafiles. See the DBA Administration manual for your version of Oracle. I expect it has an example.
HTH -- Mark D Powell -- Received on Wed Jan 06 2010 - 15:00:12 CST