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 |
You must have one of: - DBA authority
- SPACE ADMIN authority
- You own the table and have CREATE
permission on the target dbspace
|
| SAP Sybase IQ
16.0 |
You must have 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 left pane, expand , and then select
Tables.
- 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.
- 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.