Systems Engineering and RDBMS

Disable/Enable Foreign Keys and Triggers in Oracle

Posted by decipherinfosys on March 22, 2008

In one of our previous posts, we had posted a set of scripts for disabling/enabling foreign key constraints in SQL Server. In response to that post, one of the readers had asked us to post similar set of scripts for Oracle. This post addresses that question. The scripts are available below:

disable_enable_constraint_triggers_oracle.txt

2 Responses to “Disable/Enable Foreign Keys and Triggers in Oracle”

  1. […] by decipherinfosys on September 18, 2008 In one of our previous blog post, we posted the script to disable & enable constraints and triggers in Oracle. We have put […]

  2. […] our previous blog posts, we have covered trigger basics here.  We also gave the script to disable and enable the triggers and constraints in Oracle.   There is a very simple way to […]

Sorry, the comment form is closed at this time.

 
%d bloggers like this: