9. Ensuring Data Integrity : Rules : Disable Rules
 
Share this page                  
Disable Rules
By default, rules are enabled. The SET NORULES statement enables you to turn off rules when necessary (for example, when using a utility that loads or unloads a database in which tables can be modified from scripts and files prior to their processing by applications).
To issue this statement, you must be the DBA of the database to which the session is connected.
The SET NORULES statement disables any rules that apply to statements executed during the session or to the tables affected by the statements. Existing rules as well as rules created during the session are disabled.
To re-enable rules, issue the SET RULES statement.
Warning!  After you issue the SET NORULES statement, the DBMS does not enforce check and referential constraints on tables, nor does it enforce the check option for views.
For more information on using SET [NO]RULES, see the entry for the SET statement in the SQL Reference Guide.