Partitioned Table and Index

- When a table or index is partitioned, the table or index can be assigned to more than one tablespace.

- The table or index is distributed across multiple tablespaces using a partitioning key or a hashing algorithm

- An example: a histroy table
-- current data which is often queried is placed on a tablespace assigned to a faster data storage device,
-- old data placed on tablespaces assigned to slower devices

- When planning for tablespace backup with partitioned tables or indexes, consider the dependencies involved with the other tablespaces that contain the partitioned tables or indexes.