RE: enabling/ disabling constraints/ triggers

to disable:
alter trigger TRIGGER_NAME disable;

to enable:
alter trigger TRIGGER_NAME disable;

I don't know lattest versions of db, but I think there's no way to disable all constraints by one sentence

alter table TABLE NAME disable constraint CONSTRAINT NAME;

HTH
gabriel galanternik

• Original Message ----- From: bruce.taneja_at_mcd.com To: Multiple recipients of list ORACLE-L Sent: Tuesday, January 23, 2001 1:36 PM Subject: enabling/ disabling constraints/ triggers

I have never done this before .. learning DBA.. :)

• what commands can I use to enable/ disable all trigggers?
• what commands can I use to enable/ disable all constraints (if that is possible)..
• in particular do you recommend disabling any constraints while doing full imports of a database e.g. while during a migration to a higher version database (export/ import upgrade i.e.)
• any other recommendations for upgrade using export/ import related to indexes/ constraints disable/ enablement..

thanks!
Bruce

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: bruce.taneja_at_mcd.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).