Re: Moving tables/indexes from one tablespace to another

From: Greg Norris <spikey.mcmarbles_at_gmail.com>
Date: Tue, 14 Jun 2005 08:53:44 -0500
Message-ID: <d4beff36050614065321c86806@mail.gmail.com>

It's also worth mentioning that you can't use this approach when the table contains a LONG or LONG RAW column. I haven't checked 10g, but this is true as of 9iR2 anyway.

On 6/14/05, Christian Antognini <Christian.Antognini_at_trivadis.com> wrote:

> The easy way is:

>=20

> - ALTER TABLE ... MOVE TABLESPACE ...

>=20

> - ALTER INDEX ... REBUILD TABLESPACE ...

>=20
>=20
>=20

> But, you should be careful! Not only the ROWIDs change, but the data dens= ity as well. I.e. you should carefully set PCTFREE to avoid subsequent migr= ated rows or lot of splits.

--=20
"I'm too sexy for my code." - Awk Sed Fred.

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

Received on Tue Jun 14 2005 - 09:58:54 CDT