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 |
You must have CREATE permission on the target dbspace. You must also
have one of:- DBA authority
- RESOURCE authority with ALTER permission on the
table
- You own the table
|
| SAP Sybase IQ
16.0 |
You must have CREATE permission on the target dbspace. You must also
have one of:- ALTER ANY TABLE system privilege
- ALTER ANY OBJECT system privilege
- 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 left pane, expand , and then select
Tables.
- 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.
- Do one of:
- Click OK to update any changes to the
database and exit the properties view.
- Click Apply to update any changes to the database, but
remain in the properties view.
- Click Cancel to cancel any changes not
updated to the database and exit the properties view.