Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Index in unusable mode during direct load w/ singlerow

Re: Index in unusable mode during direct load w/ singlerow

From: Yongping Yao <yaoyongping_at_gmail.com>
Date: Mon, 7 Nov 2005 21:29:59 +0800
Message-ID: <706468990511070529h68cbba98w3b7241c985d699cf@mail.gmail.com>


I think you should not use sqlldr in direct mode. It will turn the index to unusable mode first.

On 11/5/05, Jessica Mao <jmao_at_portal.com> wrote:
>
> Hi,
>
> We have a range partitioned table, there's sqlldr running in direct mode
> w/ SINGLEROW option on 1 of the partitions, meanwhile there's a
> procedure who queries the table using the partition key as the only
> predicate. Every once in a while, we get an ora-1502 "index '%s.%s' or
> partition of such index is in unusable state". I thought using SINGLEROW
> should avoid such error?
>
> The db is 9.2.0.6 <http://9.2.0.6>. happens on both hp and sun platform.
>
> Thanks! -Jessica
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Yao Yongping
Learning Oracle, UNIX/Linux...
Love Reading, Classical Music, Philosophy, Economics etc.
Blog: http://blog.csdn.net/ern
http://spaces.msn.com/members/yaoyp/

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 07 2005 - 07:32:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US