RE: Moving tables/indexes from one tablespace to another

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Tue, 14 Jun 2005 10:27:47 +0200
Message-ID: <7F0C000A3ABA6241A10C9ABF37EEB46D0F0243@MSXVS01.trivadis.com>

Hi John  

>Is there any easy way to move tables and indexes from one tablespace to
>another, other than dropping and recreateing?
 

The easy way is:

• ALTER TABLE ... MOVE TABLESPACE ...
• ALTER INDEX ... REBUILD TABLESPACE ...

But, you should be careful! Not only the ROWIDs change, but the data density as well. I.e. you should carefully set PCTFREE to avoid subsequent migrated rows or lot of splits.  

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 14 2005 - 04:32:53 CDT