Re: disable a sequences

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 25 Feb 2005 06:57:10 -0800
Message-ID: <1109343430.789300.324260@f14g2000cwb.googlegroups.com>

Zibiny, Is there any command or feature to disable a sequence? No, but you can

1- revoke select from it so that no one may reference it,

2- drop and recreate it at a new value (remember to reissue grants that will be lost on the drop)

3- remove it from the insert in question

4- if the sequence value is being provided to the inserted rows via a before insert trigger you can disable the trigger and then re-enable it latter.

Perhaps one of the above will be of help.

HTH -- Mark D Powell -- Received on Fri Feb 25 2005 - 08:57:10 CST