You can alter an existing base table so that it is enabled or disabled for RLV
storage.
Prerequisites
- SAP Sybase IQ server has a simplex database.
- The RLV dbspace exists with at least one dbfile.
- You must have RESOURCE authority.
- You must be the table owner or have ALTER permission on the table.
- You must have CREATE permission on the RLV store dbspace.
TaskUse the statement ALTER TABLE
<table-name>
{ ENABLE | DISABLE} RLV STORE
- <table-name> – the name of table for which the RLV storage is to be enabled or
disabled.
- { ALTER column-name MOVE { PARTITION ( partition-name TO new-dbspace-name )
| TO new-dbspace-name } } | MOVE PARTITION partition-name TO
new-dbspace-name | MOVE TO new-dbspace-name | MOVE METADATA TO
new-dbspace-name – not supported syntax when altering an RLV-enabled table.