back to Course Categories | back | print
Oracle9i: Implementing Partitioning          

Duration: 2 days

Description 
This class will teach attendees the features and functionality of partitiong in Oracle9i. The design, management and tuning issues of partitioning are covered. The benefits and issues of the range, hash, composite, list and range-list paritioning are discussed.

Topics

  • The benefits of partitioning in large database environments
  • The management of partitions
  • How partitioning works
  • Range partitioning
  • Hash partitioning
  • List partitioning
  • Range-hash (composite) partitioning
  • Range-List partitioning
  • Partition pruning
  • Partition-wise joins
  • Equipartitioning
  • Data dictionary views for partitioned tables
  • Maintaining and modifying partitioned objects
  • ALTER TABLE partition options
  • Tuning SQL code with partitions
  • Partitioning and object-relational data types
  • Partitioning and XML data types
  • Analyzing partitioned objects
  • Partitioning indexes
  • Global prefixed indexes
  • Local prefixed indexes
  • Local non-prefixed indexes
  • Composite partitioned indexes
  • Managing partitioned indexes
  • Data dictionary views for partitioned indexes
  • Export, Import and SQL*Loader and partitioning
  • Parallel query on partitioned objects
  • Parallel DML on partitioned objects
  • Partitioning materialized views
  • Rules to follow when partitioning

Prerequisites

  • Oracle9i DBA Fundamentals I
  • Oracle9i DBA Fundamentals II


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design