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.
any, table-level, row-level
any
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.
Value |
Action |
---|---|
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. |