Any table can be partitioned up to a million separate partitions except those tables containing columns with
RAW data types. You can, however, use tables containing columns with
BLOB data types.
This sections contains the following topics:
To reduce disk and memory usage (specifically, the buffer cache), you can store tables and partitions of a partitioned table in a compressed format inside the database. This often improves scaleup for read-only operations. Table compression can also speed up query execution. There is, however, a slight cost in CPU overhead.
Oracle Database Administrator's Guide for information about guidelines for managing tables
Tables that are greater than 2 GB.
These tables should always be considered as candidates for partitioning.
Tables that contain historical data, in which new data is added into the newest partition.
A typical example is a historical table where only the current month's data is updatable and the other 11 months are read only.
Tables whose contents must be distributed across different types of storage devices.