Oracle Partitioning enhances the manageability, performance, and availability of large databases.
Partitioning is powerful functionality that allows tables, indexes, and index-organized tables to be subdivided into smaller pieces, enabling these database objects to be managed and accessed at a finer level of granularity. Oracle provides a comprehensive range of partitioning schemes to address every business requirement. Moreover, since it is entirely transparent in SQL statements, partitioning can be used with any application, from packaged OLTP applications to data warehouses.
Oracle supports a wide array of partitioning methods:
Partitioned tables can be created as internal heap or index organized tables, as external tables, and beginning with Oracle Database 19c as hybrid partitioned tables. The availability of individual partitioning methods varies with the type of the table.