Partition and conquer
Raj Pande · 2017
With Oracle8, the lowest level of granularity for data storage has been lowered from tables to partitions. A table can have many partitions, each with the same logical attributes, but with different physical attributes. The concept of partitioning opens up new possibilities in terms of tuning and database administration. However, at least in the current release, partitioning comes with a lot of constraints that the DBA must be aware of. Partitions cannot be used, for example, with tables that use the object extension of Oracle8.