Applies to RLV-enabled tables only (as opposed to all base tables in the database). Controls whether RLV-enabled tables are accessed using single-writer table-level versioning, or multiple writer row-level versioning. This option does not apply to the IQ catalog store.
Value |
Action |
---|---|
row-level |
Enables concurrent writer access and row-level versioning for RLV-enabled tables. The first transaction to modify a table row establishes a row write lock that persists until the end of the transaction. Subsequent transactions attempting to modify a locked row either fail with a lock/future version error, or block until the lock is released based on the value of the BLOCKING option. |
table-level |
Enables single-writer access and table-level versioning. The first transaction to access the table establishes a table write lock which persists until the end of the transaction. Subsequent transactions attempting to write to a locked table either fail with a lock/future version error, or block until the lock is released based on the value of the BLOCKING option. |
table-level
Requires the SET ANY PUBLIC OPTION system privilege to set this option for PUBLIC or for other user or role.