modify constraint to be deferrable !
From: Orna Berlinsky <ornab_at_amdocs.com>
Date: 20 Aug 2001 08:55:34 -0700
Message-ID: <4e2fb3ee.0108200755.184ecf6d_at_posting.google.com>
Date: 20 Aug 2001 08:55:34 -0700
Message-ID: <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
Why ? what am I doing wrong ??
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
Orna
Received on Mon Aug 20 2001 - 17:55:34 CEST