You can move the table 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 one of: - DBA authority.
- SPACE ADMIN authority.
- You own the table and have CREATE permission on the target
dbspace.
|
| SAP Sybase IQ
16.0 |
Requires one of: - ALTER ANY TABLE system privilege.
- ALTER ANY OBJECT system privilege.
- MANAGE ANY DBSPACE system privilege.
- ALTER permission on the table and CREATE permission on the
target dbspace.
- You own the table and have CREATE permission on the target
dbspace.
|
-
The
SAP Sybase IQ resource is authenticated and running.
-
In a multiplex configuration, the coordinator node is
running.
-
The table is an SAP Sybase IQ
base table (not an IQ 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 one or more tables from the right pane and either:
- Click the arrow to the right of the name and select
Move, or
- From the Administration Console menu bar, select .
Use Shift-click or Control-click to
select multiple tables.
- In the Move Object Dialog view, click the arrow and select the new dbsapce.
- Click OK to execute the move.
- Click OK to save the change and close the Move Object Dialog
view.