Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Transferring a table from one to another tablespace
> In 8.1.6, it's all very easy: alter table blah move tablespace B. That
> really does move the old object, so permissions and constraints are
> preserved. Unfortunately, all the indexes on that table are still
pointing
> at the old table blocks, and hence need to be rebuilt, but that's not too
> much effort.
>
Thank you
Nicolas
Received on Tue Feb 13 2001 - 03:08:22 CST