Oracle8 Databases Administration

Oracle 8I/9i: Databases Adminstrators
Back to Main Page

Course Description

In this course, the trainee will be introduced to the new features of Oracle8I, enhancements to existing features and general architectural differences in Oracle8I server technology. Trainees would learn the effect Oracle8I has on tasks related to maintaining and administering databases.

Course Objectives

Learn the architectural changes and additions in Oracle8I.

Understand the newer tasks of a DBA and changes to existing roles

Discuss application migration issues to Oracle8I/9i.

Intended Audience

Administrators who have experience in maintaining Oracle7 and earlier database versions

Prerequisites

Oracle7- Database Administration

Course Contents

A. Oracle8I/9I Features Overview

New features
Enhancements to existing features
Object-oriented (OO) terminology
Object-oriented methodology
Implementation of Objects in Oracle8
New ROWID format

B. Data Related Issues

Partition Rules for Tables and Indexes
Parallel DML statements
Manage Large Objects (LOBs)

C. Utilities

Password Management
Recovery Manager
SQL*Loader
Export/Import
Explain Plan

D. Queuing

Advanced queuing operations
Enqueue/dequeue facilities

E. Performance Tuning Issues

F. SQL*Net related topics

SQL*Net8 components
Security Issues

G. Migrate databases and applications from Oracle7/8 to Oracle8i/9i

H. Replication and Parallel Server Features