Re: How to drop duplicate constraints?

From: Graham C Thornton <graham.thornton_at_ln.ssw.abbott.com>
Date: Tue, 20 Apr 1999 17:05:40 -0500
Message-ID: <7fitog$ar3@news.abbott.com>

If I try to create the same constraint twice I get the following error:

ERROR at line 1:
ORA-02275: such a referential constraint already exists in the table

Could you elaborate on your problem?

Thanks

Graham

Andy Hardy wrote in message ...
>Hi,
>
>After a few reloads of an export file, I now have a database with
>several copies of the same constraints.
>
>How can I get rid of the duplicates? I tried using the constraints
>tables, but they store the search_condition in a long making it hard to
>compare them...
>
>Andy
>--
>Andy Hardy. PGP key available on request
>===============================================================
Received on Tue Apr 20 1999 - 17:05:40 CDT