Re: Tablespace in Index

From: Vincent Ventrone <vav_at_mitre.org>
Date: Mon, 11 Oct 1999 14:25:08 -0400
Message-ID: <38022B84.24A571A0@mitre.org>

Leszek Taratuta wrote:
>
> Hi,
> I would like to change a tablespace for created index. ALTER INDEX do not
> change the tablespace. DROP INDEX and CREATE INDEX is too complex.
> Does anybody know another solution of my problem ?

If you are running 7.3.? you can rebuild the index in a new tablespace -- this procedure will not drop the old one till the new if finished:

ALTER INDEX...REBUILD TABLESPACE foo....

(Note: I'm not sure exactly which 7.3 release this was introduced...)

Vincent Ventrone    |  The MITRE Corp.
DBA, Dept. R101     |  M/S C020
vav_at_mitre.org       |  202 Burlington Rd.
(781) 271-7048      |  Bedford, MA 01730

Received on Mon Oct 11 1999 - 13:25:08 CDT