Quick move tablespace
From: bob123 <bob123_at_gmail.com>
Date: Wed, 6 Jan 2010 21:18:21 +0100
Message-ID: <4b44f00b$0$24783$426a74cc_at_news.free.fr>
Hi,
Date: Wed, 6 Jan 2010 21:18:21 +0100
Message-ID: <4b44f00b$0$24783$426a74cc_at_news.free.fr>
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 Wed Jan 06 2010 - 14:18:21 CST