Re: Triggers and Constraints

Hi,

  You can disable trigger by: Alter table <table_name> disable all triggers;
(enable them by alter table <table_name> enable all triggers), for the constraints (are you very sure you want to disable them?) apply: alter table <table_name> disable constraint <constraint_name>; You can find constraint -and tablenames by querying user_constriants;

Be Carefull!

Mario Broodbakker, ook The Netherlands.

cmtnl_at_worldaccess.nl wrote in article <N.100596.161129.73_at_wxs3-7.worldaccess.nl>...
> Who can tell me something about the working of triggers and constraints
 in an
> Oracle database. Especially in what why can I turn the triggers and
 constraints
> on and off.
>
> I want to fill an Oracle database by means of an ODBC-driver and a
 MSAccess
> interface ( self-made ). I am not able to make some updates in the
 database
> because it is prohibited by the constraints and triggers of the database.
 I am
> familiar with the data structure of the database, so I will not destroy
 the
> integrity of the database.
>
> P.P.J. Hensgens, The Netherlands
>
>
  Received on Sun Oct 06 1996 - 00:00:00 CEST