Re: Has anyone seen something like this?
From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: Tue, 6 Apr 2010 09:01:13 -0700 (PDT)
Message-ID: <5d1e9464-978b-4753-88b7-10814f43ffb2_at_i37g2000yqn.googlegroups.com>
On Apr 6, 6:33 pm, Mladen Gogala <n..._at_email.here.invalid> wrote:
> The database is 10.2.0.4, linux x86-64. No RAC, just plain vanilla FS.
>
> SQL> select index_name,table_name from user_indexes
> 2 where status='UNUSABLE';
>
> INDEX_NAME TABLE_NAME
> ------------------------------ ------------------------------
> SEG_MIG_PUBLISHED SEGMENT_MIG
>
> Elapsed: 00:00:00.12
> SQL> drop index SEG_MIG_PUBLISHED;
> drop index SEG_MIG_PUBLISHED
> *
> ERROR at line 1:
> ORA-01418: specified index does not exist
>
> Trying to rebuild produces the same result. I opened a SR.
>
> --http://mgogala.byethost5.com
Date: Tue, 6 Apr 2010 09:01:13 -0700 (PDT)
Message-ID: <5d1e9464-978b-4753-88b7-10814f43ffb2_at_i37g2000yqn.googlegroups.com>
On Apr 6, 6:33 pm, Mladen Gogala <n..._at_email.here.invalid> wrote:
> The database is 10.2.0.4, linux x86-64. No RAC, just plain vanilla FS.
>
> SQL> select index_name,table_name from user_indexes
> 2 where status='UNUSABLE';
>
> INDEX_NAME TABLE_NAME
> ------------------------------ ------------------------------
> SEG_MIG_PUBLISHED SEGMENT_MIG
>
> Elapsed: 00:00:00.12
> SQL> drop index SEG_MIG_PUBLISHED;
> drop index SEG_MIG_PUBLISHED
> *
> ERROR at line 1:
> ORA-01418: specified index does not exist
>
> Trying to rebuild produces the same result. I opened a SR.
>
> --http://mgogala.byethost5.com
Please include INDEX_TYPE in your query. If this is a DOMAIN (Oracle Text, for example) index, ORA-1418 might be thrown when index creation crashed and index state can not be determined. If this is the case, try DROP INDEX xxx FORCE. Should get rid of it.
Hth,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
Received on Tue Apr 06 2010 - 11:01:13 CDT