> -----Original Message-----
> From: Kevin Lange [mailto:[EMAIL PROTECTED]]
>
> 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