Kurz Oracle Implement Partitioning

  • Oracle Partitioning methods for tables, index, and materialized views that are available in Oracle Database 11g Release 2 with examples and explanations of appropriate use.

  • Understand the partitioning advantages and architecture
  • Explore various partition types in the Oracle RDBMS
  • Understand the partition options, creating partition tables and indexes
  • Specify relationships between table and index
  • Identify the associated overhead with maintenance commands
  • Verify the partitioning structure
  • Explore and create Materialized Views
  • Track the performance of a partitioned materialized views
  • Set various partitioning options in regard to the features of databases
  • Explore Oracle Enterprise Manager to support partitioned objects