Re: Moving partitioned indexes in Oracle8

Try alter index rebuild partition... (can't remember exact syntax, something like that...)

Good luck,
Dave

aa_at_triad.com wrote in message <6g0i0s$5dg$1_at_nnrp1.dejanews.com>...
>I can't seem to find a way to move an index partition from one tablespace
 to
>another in Oracle8.
>
>When I added a new partition to an existing partitioned table the local
>partitioned non-prefixed indexes by default got created in the same
 tablespace
>as the base table. I need to move the index partitions to another
 tablespace.
>
>If you have come across this problem before please let me know how you
 worked
>around it.
>
>Thanks,
>Arun
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Sat Apr 04 1998 - 00:00:00 CST