Moving partitioned indexes in Oracle8

From: <aa_at_triad.com>
Date: 1998/04/02
Message-ID: <6g0i0s$5dg$1@nnrp1.dejanews.com>#1/1

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 Thu Apr 02 1998 - 00:00:00 CST