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 -> How to find the index for a constraint

How to find the index for a constraint

From: Lothar Armbrüster <la_at_oktagramm.de>
Date: Tue, 12 Jun 2001 18:53:59 +0200
Message-ID: <PM0003868CF1BEEB33@hades.unknown.dom>

Hello out there,

I'm looking for a method to find the index name for a, say, primary key constraint. Normally the index is named like the constraint, but today I came upon a table where the constraint seemed to use another index. I wanted to drop an index but Oracle said this index could not be dropped:

ORA-02429 cannot drop index used for enforcement of unique/primary key

But this index had the PK column and one additional column. The index named like the constraint also existed.
After I did "alter table ... drop primary key" I could drop the index. I wasn't droped with the constraint.

I look for a data dictionary view which shows me the connection between index and constraint, but I cannot find one which contains INDEX_NAME and CONSTRAINT_NAME.

The system ist Oracle 8.1.7 on NT4.

Many thanks in advance,
Lothar

-- 
Lothar Armbrüster       | la_at_oktagramm.de
Hauptstr. 26            | la_at_heptagramm.de
D-65346 Eltville        | lothar.armbruester_at_t-online.de
Received on Tue Jun 12 2001 - 11:53:59 CDT

Original text of this message

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