Re: search_name = <<error>>

Yes, you are right.

I finally was able to see it when I used another console.

Thanks,

Mike

Bricklen wrote:
>
> 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 - 13:00:27 CDT