Re: Indexes going into DIRECT LOAD status

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 27 Jan 1999 17:44:35 -0000
Message-ID: <917458995.8853.1.disrupt.9e984b29@news.demon.co.uk>

Are they bitmap indexes ?

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

david_neal_at_cantor.com wrote in message <78niio$9mu$1_at_nnrp1.dejanews.com>...
>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:44:35 CST