Re: drop index help

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sat, 23 Jun 2001 12:09:03 -0700
Message-ID: <3B34E94F.DA37BCE8@exesolutions.com>

Steve wrote:

> I would like to get help:
>
> Somehow a table is corrupted and I would drop primary key index (this is the
> only one) and re-create it for a try. But I can't drop the primary key
> index on two columns even though I have disable the foreign keys and its
> primary key first.
>
> The error is "specified index does not exist" when 'drop index xxx'.
>
> Any thought would be appreciated.
>
> Steve

The index may not exist but the constraint may. Look in user_indexes and user_constraints to determine what is actually there.

Daniel A. Morgan Received on Sat Jun 23 2001 - 14:09:03 CDT