Re: Duplicate Constraints

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: 20 Sep 2006 00:43:33 -0700
Message-ID: <1158738213.433721.310100@i42g2000cwa.googlegroups.com>

al1 wrote:
> Oracle 9i
>
> We have identified numerous duplicate constraints in our database on
> some tables, I read an article where this is related to exp and imp
> with unnamed constraints.
>
> My question is how do we identify these duplicate constraints and
> remove them without having to manually go through every single table, I
> tried the query below to identify dups, but had no luck as
> search_condition is a long data type and has restrictions and wont
> allow a group by.
>
> select count(*) , table_name , search_condition
> from sys.all_constraints
> where owner = 'XXX'
> group by table_name , search_condition
> having count(*) > 1
>
> Thx In advance

Check
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:896796299899

Gints Plivna
http://www.gplivna.eu Received on Wed Sep 20 2006 - 02:43:33 CDT