global indexes

From: DJ <nospamplease_at_goaway.com>
Date: Wed, 26 Nov 2003 19:35:46 -0000
Message-ID: <ng7xb.4086$qn4.33940@newsfep4-glfd.server.ntli.net>

Hi, Oracle 9iR2 - Linux RedHat 9

I have a normal table called cs_actype_map and a partitioned table called cs_actype_map_tmp with one partiotion called part.

The cs_actype_map table has 2 indexes i1_cs_actype_map and i2_cs_actype_map

We are loading into this tmp table and exchanging partitions like this

alter table cs_actype_map_tmp exchange partition part with table cs_actype_map update global indexes.

Now what is happening is that the two indexes on the table are going unusable.

My question is shouldnt the update global indexes part stop the indexes becoming unusable on the table? Received on Wed Nov 26 2003 - 13:35:46 CST