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>


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

Original text of this message