[Q] How oracle rebuild index internally?

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Thu, 1 Apr 2004 12:52:00 -0800 (PST)
Message-ID: <20040401205200.22651.qmail@web60808.mail.yahoo.com>

several days ago, I analyze my tables and indexes and found one index is bad. I use "alter index indexname rebuild;". ORACLE don't allow me to do it due to original index is bad. I wonder when ORACLE doing index rebuild it does NOT reread from table but reread from old index. Is it true?

The version we use is ORACLE 9ir2 (9.2.0.4).

Thanks.

---

Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu Apr 01 2004 - 15:00:57 CST