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

Home -> Community -> Usenet -> c.d.o.server -> Re: Index doesn't exit error

Re: Index doesn't exit error

From: Marc Blum <marc_at_marcblum.de>
Date: Tue, 09 Oct 2001 13:07:17 GMT
Message-ID: <1103_1002632837@pc-marcblum>


On 9 Oct 2001 12:59:30 GMT, mmoore96_at_my-deja.com wrote:
>
> I'm trying to drop an index and get a ORA-1418 index does not exist. I look
> in user_ind_columns and can find it. I look in user_indexes and its not
> there. Can anyone help?
>
> TIA
> Mike
>
> ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web -----
> http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
> NewsOne.Net prohibits users from posting spam. If this or other posts
> made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net

perhaps the owner of the index differs from the owner of the table?

Check ALL_INDEXES and ALL_IND_COLUMNS, there you find an attribute OWNER.

regards

Marc Received on Tue Oct 09 2001 - 08:07:17 CDT

Original text of this message

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