You can move SAP Sybase IQ table
objects—including indexes, columns, and partitions—from the current dbspace to another
dbspace. This feature is available only for tables in the IQ main store.
Prerequisites
| Database Version |
Table Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires CREATE permission on the target dbspace.Also requires one of: - DBA authority.
- RESOURCE authority with ALTER permission on the table.
- You own the table.
|
| SAP Sybase IQ
16.0 |
Requires CREATE permission on the target dbspace.Also requires one of: - ALTER ANY TABLE system privilege.
- ALTER ANY OBJECT system privilege.
- Requires MANAGE ANY DBSPACE system privilege.
- You own the table.
|
-
The
SAP Sybase IQ resource is authenticated and running.
-
In a multiplex configuration, the coordinator node is
running.
-
The table is a base table (not a catalog store table, global temporary table, or
proxy table).
Task- In the Perspective Resources view, select the resource and
select .
- In the Administration Console, expand .
- Select a table from the right pane and either:
- Click the arrow to the right of the name and select
Properties, or
- From the Administration Console menu bar, select .
The Table Properties view appears.
- In the left pane, select Table Objects.
- In the right pane, select an object (index, column, partition) and click
Move.
- In the Move Object Dialog view, click the arrow and select the new dbspace.
- Click OK to execute the move.
- Click OK to save the change and close the Table Properties
view.