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

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

Index in unusable mode during direct load w/ singlerow

From: Jessica Mao <jmao_at_portal.com>
Date: Fri, 4 Nov 2005 11:05:10 -0800
Message-ID: <E5158D5C4683FE4FB437ED33ADE7D1C00951C3@CUPMAIL.portal.com>


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. happens on both hp and sun platform.

Thanks! -Jessica

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 04 2005 - 13:12:14 CST

Original text of this message

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