Split range or hash-range partitions in a table.
Prerequisites
| Database Version |
Table Partition Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Table owned by self – None required.Table owned by other users – Requires one of: - DBA authority.
- ALTER permission on the table.
- SELECT permission on the table.
|
| SAP Sybase IQ
16.0 |
Requires one of:- SELECT ANY TABLE system privilege.
- SELECT permission on table.
Also requires one of:- ALTER ANY OBJECT system privilege.
- CREATE permission on the dbspace along with one of:
- ALTER ANY TABLE system privilege.
- ALTER permission on the table.
- You own the table.
|
-
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 range or hash-range partition from the list and click
Split.
- Specify the name, value, and dbspace for each resulting partition and click
OK. (You can rename the existing partition, but cannot edit
its upper bound or dbspace.)
- Click Apply or OK to complete the
split.