Oracle9i Database: Implement Partitioning

Description:

This course covers in depth the management of table and index partitioning in the Oracle RDBMS. This includes purpose, administration and syntax of commands. Design and performance issues are mentioned. This course is an immediate prerequisite to the course D13289GC10 Oracle9i: Data Warehouse Administration. These two courses can be taken in the same week.

While this course is complete and is targeted at a larger audience, some detail of partitioning performance is deferred to the Data Warehouse course.

This course counts towards the Hands-on course requirement for the Oracle Database 9i Administrator Certification and Oracle Database 10g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses are excellent study and reference tools but DO NOT meet the Hands-on Requirement for certification.

Réservation / Achat	Méthodes de Formation	Prix	Durée	Support	Formateur
Sessions planifiées	Cours en salle avec Formateur (ILC)	US$ 320 *	2 Jours	Anglais

* Instructor-Led Training pricing is subject to change based on education center location.

 

Attention !: Pour une approche plus personnalisée, merci de vous: Identifier!

Attention !:Ce cours est dispensé en français.

Audience:

• Administrateurs de base de données

Cours pré-requis:

Cours pré-requis obligatoire(s):

• Oracle9i Database Administration Fundamentals I
 

Cours pré-requis conseillé(s):

 

Objectifs:

• Choose appropriate partition attributes (keys, storage, types) for various application requirements
• Create tables and indexes that are partitioned
• Verify and modify the table and index partitioning and attributes thereof
• Understand partitioning options with other database features

Thèmes abordés:

Understanding the Partitioning Design

• The Management and Performance Benefits (Partition Elimination)
• Tablespace, Segment, Table, and Partition Relation
• Range, Hash, and List Partitions

Partitioning of Tables

• Commands and Syntax
• Viewing Partition Information

Partitioning of Indexes

• Relation to Table Partitioning
• Commands and Syntax

Modifying Partitions and Partition Attributes

• Merge, Split, Exchange, and Move
• Indexing

Application and Use of Partitions

• Export, Import and SQL*Loader
• Parallel Query and DML

Cours suivant(s) conseillé(s):

• Oracle9i: Data Warehouse Administration