🚀 go-pugleaf

Yes, you only can change constraint_state in alter table modify
constraints.. clause.
BUT if you really need to change that in one SQL here there is:
 (connect as user who got privileges to sys obj)


UPDATE sys.cdef$
   SET condition = New_Codition_Here
 WHERE con# = (
   select c.con#
     from sys.obj$ o, sys.cdef$ c, sys.con$ oc
    where c.obj# = o.obj#
      and o.name = 'TTT'
      and oc.name = 'E'
      and oc.con# = c.con#
     );

Have Fun.


U�ytkownik "Sybrand Bakker" <postbus@sybrandb.demon.nl> napisa� w wiadomo�ci
news:tk6o36hpr5h2c1@beta-news.demon.nl...
>
> "penny" <boy_66@hotmail.com> wrote in message
> news:a7c8116a.0107040956.24128126@posting.google.com...
> > Hi all,
> >
> >
> > I am using Oracle8i Enterprise Edition in window 2000
> >
> > my problem as following
> >
> >
> >
> > ~~~~~~~~~~~~~~~~~~~~~
> >
> > SQL>  create table ttt
> >   2   ( name varchar2(100)
> >   3   ,
> >   4   constraint e check (name = lower(name)));
> >
> > Table created.
> >
> > SQL> alter table ttt
> >   2  modify constraint e
> >   3  check (name = upper(name));
> > check (name = upper(name))
> > *
> > ERROR at line 3:
> > ORA-00933: SQL command not properly ended
> >
> >
> >
> > How can I modify constraint e ????
> >
> >                                   thanks.
>
>
> You can't
> You need to drop the constraint and recreate it.
> Please try to consult the sql reference manual before posting these typing
> of questions.
>
> Regards,
>
> Sybrand Bakker, Senior Oracle DBA
>
>
>