Re: search_name = <<error>>

Michael Hill wrote:
> 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

I just ran this:
create table abc (id VARCHAR2(6),cd integer);

alter table abc add constraint ck_cd check (cd in ('Y','N')); select * from all_constraints where table_name='ABC';

on a 92010 db and it returned the expected results. note that you have a typo in your create table statement (comma at the end), and I changed the varchar to varchar2. Received on Thu Oct 07 2004 - 12:39:48 CDT