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