Move a table partition to another dbspace.
Prerequisites
| Database Version |
Table Partition Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires one of:- DBA authority.
- SPACE ADMIN authority
- CREATE permission on the dbspace to which the partition is being
moved along with one of:
- ALTER permission on the underlying table.
- You own the table.
|
| SAP Sybase IQ
16.0 |
Requires one of: - ALTER ANY TABLE system privilege.
- ALTER ANY OBJECT system privilege.
- MANAGE ANY DBSPACE system privilege.
- One of the following:
- CREATE ANY OBJECT system privilege.
- CREATE permission on the dbspace to which the
partition is being moved.
- Along with one of:
- ALTER permission on the underlying table.
- You own the underlying table.
|
-
You have CREATE permission in the new dbspace.
-
The
SAP Sybase IQ resource is authenticated and running.
-
In a multiplex configuration, the coordinator node is
running.
-
You are licensed for the Very Large Database Management option
(IQ_VLDBMGMT).
Task- In the Perspective Resources view, select the resource and
select .
- In the Administration Console, expand .
- Select Tables, select the table in the right pane, click
the drop-down arrow that appears beside the table name, and select
Properties.
- Select Partitions.
- Select a partition from the list and click Move.
- Select the new dbspace from the drop-down list and click
OK.
- Click Apply or OK to complete the
move.