Re: question about disable constraints and/or triggers

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 7 Feb 2004 16:50:10 -0800
Message-ID: <2687bb95.0402071650.25d8b83c@posting.google.com>

"The Legend" <invalid_at_invalid.nl> wrote in message news:<c03ftp$jk8$1_at_news.cistron.nl>...
> Hello ,
>
> I am a database newbee and have a question about the 8 and or 9 versions of
> oracle.
>
> I am not familiar with these versions cause still testing arround on 7.I
> have seen some gui admin tools disable en enable triggers in a sec?
>
> It this easily done on a sql prompt also? I use the drop and create commands
> but is disable and enable command also available on the older versions ?
>
> greets,
>
> Ed

Yes, the enable and disable clauses werre/are part of the constraint clause in at least some of the Oracle 7.x releases. It is/was probably available since 7.0 but that is too far back for me to remember.

Just try the commands using the same syntax found in the current manuals.

HTH -- Mark D Powell -- Received on Sat Feb 07 2004 - 18:50:10 CST