Re: Quick move tablespace

From: Mark D Powell <>
Date: Wed, 6 Jan 2010 13:00:12 -0800 (PST)
Message-ID: <>

On Jan 6, 3:18 pm, "bob123" <> 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

Original text of this message