Splitting a Partition

Split a range or hash-range partition in a table.

Prerequisites

Database Version	Table Partition Privileges
SAP Sybase IQ 15.3 and 15.4	Table owned by self – none. Table owned by other users – you must have one of: DBA authority ALTER permission on the table SELECT permission on the table
SAP Sybase IQ 16.0	You must have one of: SELECT ANY TABLE system privilege SELECT permission on table You must also have 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

Database Version

Table Partition Privileges

SAP Sybase IQ 15.3 and 15.4

Table owned by self – none.

Table owned by other users – you must have one of:

SAP Sybase IQ 16.0

You must have one of:

You must also have 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 must be licensed for the Very Large Database Management option (IQ_VLDBMGMT).

Task

In the Perspective Resources view, select the resource, and select Resource > Administration Console.
In the left pane, expand IQ Servers > Schema Objects > Tables, and then select Tables.
Select an IQ main store 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 Resource > Properties.
The Table Properties view appears.
In the left pane, select Partitions.
Select a range or hash-range partition from the list and click Split.
Specify the name, value, and dbspace for the new partition. You can rename the existing partition, but cannot edit its upper bound or dbspace. Click OK.
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.