Has anyone seen something like this?

From: Mladen Gogala <no_at_email.here.invalid>
Date: Tue, 6 Apr 2010 14:33:03 +0000 (UTC)
Message-ID: <pan.2010.04.06.14.33.03_at_email.here.invalid>

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

Received on Tue Apr 06 2010 - 09:33:03 CDT