Re: Urgent!! - Deferred constraints

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 11 Oct 1999 08:51:02 +0100
Message-ID: <939628512.20911.1.nnrp-04.9e984b29@news.demon.co.uk>

This looks okay, and I've just run it through on my 8.1.5 system -

Which version of Oracle ? deferrable constraints only came into existence in 8.

Are you sure you don't have a typing error (or hidden character) hiding somewhere in your original statement.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Evelyn wrote in message <38009c8e_2_at_news.ausmail.com>...

> alter table DEPARTMENT add (
> constraint mgrssn_fk foreign key (mgrssn) references
>EMPLOYEE(ssn) initially deferred deferrable );
Received on Mon Oct 11 1999 - 02:51:02 CDT