Benefits of Partioning
•Availability
–Partions can be
independently managed
–Backup and restore
operations can be done on individual partitions
–Partitions that are
unavailable do not affect queries on DML operations on other paritions that use the
same table or index
•Manageability
–A partition can be moved
from one tablespace to another
–A partition can be
dropped, truncated, added
–A partition can be
divided at user-defined value