Re: question about disable constraints and/or triggers

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sat, 07 Feb 2004 23:08:30 +0100
Message-ID: <8coa20l16qalaqfu32c056pu0jrorrnb1t@4ax.com>

On Sat, 7 Feb 2004 20:56:48 +0100, "The Legend" <invalid_at_invalid.nl> wrote:

>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
>

alter table <table> disenable|enable <constraint_name> has been available since the earliest incarnations of V7. Apart from that it can be looked up on
http://otn.oracle.com/documentation

--
Sybrand Bakker, Senior Oracle DBA

Received on Sat Feb 07 2004 - 16:08:30 CST