Duplicate check constraints on the same column

From: Limin Guo <guo_at_andrews.edu>
Date: 1997/11/20
Message-ID: <Pine.SOL.3.91.971120134427.12601A-100000@deepika.squonk.net>#1/1

On one of my development Oracle server (Oracle 7.3.3 on Windows NT 4.0) we found something interesting: duplicate check constraints on the same columns. Following is an example:

SQL> select constraint_name, search_condition   2 from all_constraints
  3 where table_name = 'C_CLIENT_REFERRALS'

CONSTRAINT_NAME SEARCH_CONDITION

---------------------------   -------------------------------------------

CCR_CC_PK
CCR_PRG_FK
.
.

SYS_C0011051			cc_client_id BETWEEN 1 AND 999999
SYS_C0011052			prg_program_id BETWEEN 'A' AND 'ZZZZZ'
SYS_C0011053			to_from_flag IN ('T', 'F')

.
.

SYS_C00918			cc_client_id BETWEEN 1 AND 999999
SYS_C00919			prg_program_id BETWEEN 'A' AND 'ZZZZZ'
SYS_C00920			to_from_flag IN ('T', 'F')

This perticular database was created months ago and fully imported from the other one. We don't have any duplicate check constraints on the original one. Also this doesn't look to me like someone created those check constraints manually because of the default constraint names. This problem happened on some other tables as well.

How could it happen?

Thanks for any clues and suggestions.

Regards,

Limin. Received on Thu Nov 20 1997 - 00:00:00 CST