Re: Duplicate check constraints on the same column

On Thu, 20 Nov 1997 14:15:37 -0500, Limin Guo <guo_at_andrews.edu> wrote:

>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.

Presumably you've checked that the same table does not exist in two schemas? Received on Fri Nov 21 1997 - 00:00:00 CST