Oracle Database 11g: Partitioning Overview Seminar

This Seminar will discuss the Oracle Partitioning methods for tables and indexes that are available in Oracle 11g with examples and explanations of appropriate use.

Oracle Database 11g Introduces several new partitioning methods: Reference Partitioning, System Partitioning, Interval Partitioning, Virtual Column Partitioning and several new composite Partitioning methods: Range-Range, Hash-Hash, List-List, List-Hash, List-Range and Interval-Range,Interval-Hash and Interval-List. When added to all the existing methods this large choice requires that DBAs and Architects understand each method and appropriate uses for physical modeling in Data Warehouse Information Lifecycle Management and other types of applications.

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Audience

• Database Administrators
• Data Warehouse Administrator
• Database Designers
• Technical Administrator

Course Topics Introduction to Partitioning Table Partitioning Index Partitioning Partition Maintenance Partition Interaction with othe Oracle Features
Course Objectives

• Learn all Oracle Partitioning Methods for tables and indexes