RE: Constraints

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 08 Jan 2002 13:38:52 -0800
Message-ID: <F001.003EA4AE.20020108130531@fatcity.com>

> -----Original Message-----
> From: Kevin Lange [mailto:kgel_at_ppoone.com]
>
> There are not supposed to be any Duplicate Constraint names in your
> Database, right ??
>
> Right now I have a database that has 48 constraints that are
> duplicated in
> name.  They are constraints that have a system generated name.
>
> Its on Oracle 8.0.5.   Anyone know of any known bug that
> would allow this ?

The constraints probably have different owners. See example below.

LQS> create table wolfgang.t (n number not null) ;

Table créée.

LQS> select constraint_name from dba_constraints   2  where owner = 'WOLFGANG' and table_name = 'T' ;

CONSTRAINT_NAME

---

SYS_C001631 LQS> create table amedeus.t (n number constraint sys_c001631 not null) ;

Table créée.

LQS> select owner, constraint_name
  2  from dba_constraints
  3  where owner in ('WOLFGANG', 'AMEDEUS') and table_name = 'T' ;

OWNER                          CONSTRAINT_NAME
------------------------------ ------------------------------
WOLFGANG                       SYS_C001631
AMEDEUS                        SYS_C001631

Received on Tue Jan 08 2002 - 15:38:52 CST