Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> search_name = <<error>>

search_name = <<error>>

From: Michael Hill <hillmw_at_ram.lmtas.lmco.com>
Date: Thu, 07 Oct 2004 12:22:31 -0500
Message-ID: <41657B57.BE388FA@ram.lmtas.lmco.com>


I created a table like:

create table abc
(
id VARCHAR(6),
cd integer,
)

I then went to add a constraint like:
alter table abc
add constraint ck_cd check (cd in ('Y','N'))

this was successful, but then I executed the command:

select * from all_constraints where TABLE_NAME='ABC'

and I see the constraint, but the search_condition is "<<ERROR>>".

What is up with that?

Mike Received on Thu Oct 07 2004 - 12:22:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US