Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f6ALVBa22151 for ; Tue, 10 Jul 2001 17:31:11 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f65DxTa03447 for ; Thu, 5 Jul 2001 09:59:29 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f65DgLZ09874 for pgsql-sql@postgresql.org; Thu, 5 Jul 2001 09:42:21 -0400 (EDT) (envelope-from news) From: mark.powell@eds.com (Mark D Powell) X-Newsgroups: comp.databases.oracle.marketplace, comp.databases.oracle.misc, mailing.database.sql-general, comp.databases.postgresql.sql Subject: Re: sql startment problem PLEASE HELP ..... Date: 5 Jul 2001 06:42:19 -0700 Organization: http://groups.google.com/ Lines: 51 Message-ID: <178d2795.0107050542.4c49cf6d@posting.google.com> References: <3B43591F.5AEEBDB5@cgi.ca> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-support@google.com To: pgsql-sql@postgresql.org X-Archive-Number: 200107/117 X-Sequence-Number: 3902 Stephen Bell wrote in message news:<3B43591F.5AEEBDB5@cgi.ca>... > Hi Penny, > > I hope someone proves me wrong, but I don't think you can modify a > constraint like that....I believe you have to drop it and recreate it. > > Steve > > penny wrote: > > > 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. Penny, I believe Steve is correct. You can find the name of the constraint to be dropped and recreated using the dba_constraints dictionary view. select constraint_name, constraint_type, search_condition, status from sys.dba_constraints where table_name = upper('&table_name') / You might need to add owner to the above if you have or allow the same object_name under different owners. -- Mark D Powell --