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 -> drop index help

drop index help

From: Steve <schen_at_prodigy.net>
Date: Sat, 23 Jun 2001 14:22:47 GMT
Message-ID: <XC1Z6.180$lB4.62562488@newssvr15.news.prodigy.com>

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 Received on Sat Jun 23 2001 - 09:22:47 CDT

Original text of this message

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