DISABLE_RI_CHECK option

Function

Allows load, insert, update, or delete operations to bypass the referential integrity check, improving performance.

Allowed values

ON, OFF

Scope

DBA permissions are not required to set this option. Can be set temporary, for an individual connection, or for the PUBLIC group. Takes effect immediately.

Default

OFF

Description

Users are responsible for ensuring that no referential integrity violation occurs during requests while DISABLE_RI_CHECK is set to ON.