Re: Moving tables/indexes from one tablespace to another
- From: Greg Norris <spikey.mcmarbles@xxxxxxxxx>
- To: Oracle-L@xxxxxxxxxxxxx
- Date: Tue, 14 Jun 2005 08:53:44 -0500
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@xxxxxxxxxxxx> 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts: