Cannot Enable Table for RLV Storage

Problem: You receive an error message indicating that the table cannot be enabled for row-level versioning (RLV).

Explanation A

RLV storage cannot be enabled on tables unless the RLV store dbspace is configured.

Explanation B

RLV storage cannot be enabled on any table that has:
  • LONG BINARY (LOB) or LONG VARCHAR (CLOB) data types.
  • WORD (WD) or TEXT indexes.
  • Foreign key constraints.

Explanation C

RLV storage cannot be enabled on temporary or global temporary tables.

Parent topic: Appendix: Troubleshoot the RLV Store