Applies to all base tables in the database (as opposed to RLV-enabled tables only).
Restricts table versioning for all base tables to either table-level or row-level snapshot
versioning. This option does not apply to the IQ catalog store.
Allowed Values
any, table-level, row-level
- any – no restrictions on snapshot versioning.
- row-level – Allows only row-level snapshot versioning. Any transactions attempting
to use table-level versioning to modify a table will fail with an
Illegal snapshot isolation error.
- table-level – Allows only table-level snapshot versioning. Any transactions attempting
to use row-level versioning to modify a table will fail with an
Illegal snapshot isolation error.
Scope
Option can be set at the database (PUBLIC) level
only.
Requires the SET ANY SYSTEM OPTION system privilege to set this option. Takes effect
immediately.