Re: Tablespace in Index

From: Neil C <btsscrth_at_bt.com>
Date: Mon, 11 Oct 1999 15:06:50 +0100
Message-ID: <7tsqt5$smd$1@pheidippides.axion.bt.co.uk>

why not use the alter index rebuild .... statement (version 7.3 onwards)

ALTER INDEX schema.index_name
REBUILD
TABLESPACE new_tablespace_name;

You will need to have sufficient space to hold the index in the new tablespace, as well as quota on the new tablespace;

HTH NeilC

Leszek Taratuta wrote in message <7tsf91$1oh8$1_at_news.ipartners.pl>...
>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 ?
>
>LEU
>
>
>
Received on Mon Oct 11 1999 - 09:06:50 CDT