Adding a New Tablespace and Chunks (Partition) in a Shardspace

You may need to add a new tablespace and partition to a table sharded by directory when you want to add new groupings of keys on an existing shardspace or a newly added shardspace.

The steps involved are:

Create new tablespaces in the desired shardspace.
Run ALTER TABLE ADD PARTITION partition_name TABLESPACE tablespace_name on the sharded table, for example:
```
ALTER TABLE customers ADD PARTITION p4 TABLESPACE tb4;
```

This results in the creation of an empty partition and chunk in the specified shardspace. Subsequent inserts of new key values can then specify this new partition as the target.

If you specify the assignment rule to be last partition, all new key inserts will be automatically assigned to the new partition.