Oracle 8i New Features

PT1976
Summary
This course will introduce the student to the changes and enhancements available in Oracle Corporation's latest release - Oracle 8i. Enhancements to the relational side of Oracle 8 such as partitioning, materialized views, and new types of indexes will be discussed. Object oriented technology will also be introduced as well as the new features of the database which support object orientation. This course contains new features of both 8.0 and 8i.
Prerequisites
The student should have prior experience with an Oracle 7 database.
Duration
5 Days/Lecture & Lab
Audience
This course is designed for developers who are familiar with Oracle7.
Topics
  • Partitioned tables/indexes
  • Partitioning with the HASH and COMPOSITE method
  • Large objects (LOBs)
  • Using DBMS_LOB
  • Parallel DML
  • Increased limits
  • Index-organized tables
  • Advanced queuing
  • Reversed-key indexes
  • Oracle 8's ROWID
  • Using DBMS_ROWID
  • Dropping columns from a table
  • External procedures
  • Enhancements to constraints
  • Password management utility
  • Transportable tablespaces
  • Using DBMS_TTS
  • Read-only tablespaces
  • Using LogMiner
  • Using DBMS_REPAIR
  • Implementing invoker's rights
  • Implementing autonomous transactions
  • Use of native dynamic SQL in PL/SQL
  • PL/SQL Bulk Binds
  • Use of multiple buffer pools of SGA
  • Stored outlines
  • Materialized views
  • Managing summaries
  • Using CUBE and ROLLUP functions
  • Query re-writes
  • Function-based / Descending indexes
  • Temporary tables
  • Fine-grained access control
  • Java integration
  • Enhancements to SQL*Loader
  • Overview of objects
  • Object types/tables
  • References
  • Defining methods
  • Map methods
  • User-Defined/Order methods
  • Collection types
  • VARRAY'S
  • Nested tables
  • Object views
  • INSTEAD OF triggers

Related Scheduled Courses