Re: Moving an index

In article: <3i5agr$60j_at_sundog.tiac.net> fallin_at_max.tiac.net (Deeptendu Majumder) writes:
>
> Hi all,
>
> I am looking for ways to quickly move indexes into a new tablespace
> without dropping them and rebuilding them. I would appreciate
> suggestions about how to go about doing it. I am not even sure if
> it possible.
>
> many thanks
>
> d
>
>

-- 

	It is not possible to 'move' them. They have to be
dropped and recreated. Look at using the exp/imp utility,
specifically the indexfile parameter under imp.


---
	Tim London			phone :	+44 753 662393
	Oracle DBA,Trainer and		mobile:	+44 836 287064
	part time OU tutor		Email : tim_at_artemis.demon.co.uk