Skip to Main Content
8 Partitioning Techniques in Oracle Database

About This Workshop

Youtube Video

About This Workshop
Oracle Partitioning enhances the manageability, performance and availability of large databases. It offers comprehensive partitioning methods to address different business requirements. We can apply Database partitioning on transactional, data warehousing, and mixed workload applications without changing any code. We can use partitioning on large tables and indexes to make them smaller objects that can be managed and accessed at a more advanced level of granularity.

In this workshop, the user will learn how to create eight different types of partitioning based on their business and data requirements. The examples provided are simple, easy to run and great to understand the business use-cases behind the different types of partitions.

Workshop Info

2 hours, 45 minutes
  • Range Partitioning
  • Interval Partitioning
  • List Partitioning
  • Hash Partitioning
  • Auto-List Partitioning
  • Read-Only Partitioning
  • Multi-Column List Partitioning
  • Convert Non-partitioned Table to Partitioned Table
  • Basic knowledge of Oracle Database is required and access to any Oracle Database Instance.

Other Workshops you might like

Ask Oracle
Helping you on LiveLabs
Powered by Oracle Digital Assistant and Oracle Generative AI