unusable indexes

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Fri, 24 Nov 2000 11:16:09 -0800 (PST)
Message-Id: <10690.122867@fatcity.com>

--0-1632621729-975093369=:16455

Content-Type: text/plain; charset=us-ascii

Can anyone explain to me how a global non-partitioned index that's on a partitioned table can be rebuilt using the "alter index rebuild" command when one of the table's partitions has been truncated? I expected it to return an error since "rebuild" uses the existing index as the data source and the index is marked "unusable" as soon as the truncate completes. After I ran the rebuild however, the index was marked as VALID.

---

Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
--0-1632621729-975093369=:16455

Content-Type: text/html; charset=us-ascii

Can anyone explain to me how a global non-partitioned index that's on a partitioned table can be rebuilt using the "alter index rebuild" command when one of the table's partitions has been truncated? I expected it to return an error since "rebuild" uses the existing index as the data source and the index is marked "unusable" as soon as the truncate completes. After I ran the rebuild however, the index was marked as VALID.<BR><BR><p><br><hr size=1><b>Do You Yahoo!?</b><br> <a href="http://shopping.yahoo.com/">Yahoo! Shopping</a> - Thousands of Stores. Millions of Products.
--0-1632621729-975093369=:16455--
Received on Fri Nov 24 2000 - 13:16:09 CST