Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Transferring a table from one to another tablespace

Re: Transferring a table from one to another tablespace

From: Nicolas Bronke <newsgroup_at_trinity.de>
Date: Tue, 13 Feb 2001 10:08:22 +0100
Message-ID: <96atfa$qdn$06$1@news.t-online.com>

> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US