Indexes going into DIRECT LOAD status

Hi all,

I have a few indexes on an Oracle v7.3.2 database which are in a DIRECT LOAD status when queried from all_indexes but are fine from all_objects.

1. Which should I believe ?
2. Why does it go into this status and how can I prevent it ?

I've gotten around it so far by alter index <index_name> rebuild but I'd like to know why it's happening and stop it.

Thanks

D

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Jan 27 1999 - 11:32:08 CST