Re: Unusable index in Partitioned table

skip_unusable_indexes does not apply if your indexes are unique or used to enforce unique or primary key constraint.

do you have this situation?

hth,

jack Silvey
warehouse dba, somewhere in Texas

"bocgco" <bocgco_at_bocgco.com> wrote in message news:<3ecafb4e$1_at_shknews01>...
> In Oracle 9.2.0, solaris platform, I have encountered the following problem.
>
> As the data is loaded thru direct path loading and the index has been set
> unusable during the load. When I use select statement, the error occurred
> even in sqlplus.
>
> ERROR at line 1:
> ORA-01502: index 'MYDB.MYDATA_IDXL01' or partition of such index is in
> unusable state
>
> I have exec "alter session set unusable index=true" already but it still
> can't work. Finally I found that if all partitons' index has been set
> unusable then it will be fine. Oracle will be able to do a table scan. The
> problem occurs when only some of the partitioned index of the same table has
> been set to unusable.
>
> Do anyone have similar experience or have workaround for me ?
Received on Sun May 25 2003 - 13:55:46 CDT