Re: modify constraint to be deferrable !

ornab_at_amdocs.com (Orna Berlinsky) wrote in message news:<4e2fb3ee.0108200755.184ecf6d_at_posting.google.com>...
> Hi,
>
> If I already have constraints defined in my database as immedaite and
> I want to modify them to be deferrable, :
> ( version 8.1.7 )
>
> SQL> alter table address modify constraint address_1fk deferrable;
> alter table address modify constraint address_1fk deferrable
> *
> ERROR at line 1:
> ORA-00933: SQL command not properly ended
>
>
>
> Why ? what am I doing wrong ??
> thanks a lot
> Orna

Check the sql reference manual. You can't modify a constraint, you need to drop it and to recreate it.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Tue Aug 21 2001 - 09:15:00 CEST