Tom Kyte introduces the new partitioning improvements in Oracle Database 12c, followed by a demo of global index maintenance. For more information:
This tutorial covers Oracle Database 12c attribute clusters and zone maps, features designed to offer significant IO reduction for queries that would otherwise perform full table scans.
This tutorial shows you what is new in partitioning an Oracle Database 12c. Topics include how to:
1. Use Interval Reference Partitioning
2. Perform Cascading TRUNCATE and EXCHANGE Operations
3. Move Partitions Online
4. Maintain Multiple Partitions
5. Maintain Global Indexes Asynchronously
6. Use Partial Indexes
This demo shows how to use interval partitioning in Database 11g Release 2
In this tutorial, you learn how to use Oracle Database for high-speed data loading and leverage Oracle Partitioning for a rolling window operation.
This demo shows how to use Virtual Column Based Partitioning in Database 11g Release 2
This demo shows how to use extended composite partitioning
This demo shows how to use reference partitioning in Database 11g Release 2
This tutorial demonstrates how to use various partitioning techniques in Oracle Database 11g. Note: This OBE was tested on production software however some of the screenshots may still refer to the beta software.
This demo shows how to use interval partitioning
In this tutorial, you learn how to use Oracle10g for high-speed data loading and leveraging Oracle Partitioning for a rolling window operation.