Oracle8: Files, Data, and Users

Synopsis
Oracle8: Files, Data, and Users shows users how to manage files, import and export data, and manage user accounts.

Audience
This course is for anyone who is interested in learning about handling files and user accounts in Oracle8.

Time
6 hours

Product Code: ORCC04

After completing Oracle8: Files, Data, and Users, the user should be able to:

Use redo log files

Describe control files and rollback segments

Create user accounts

Manage user accounts

Manage user roles

Redo Log Files

Understanding redo log files

Using switches and checkpoints

Sizing redo log files

Archiving redo log files

Using the ALTER DATABASE command

Control Files and Rollback Segments

Using control files

Understanding rollback segments

Managing Rollback Segments

Creating rollback segments

Tuning rollback segments

Creating User Accounts

Administering user accounts

Creating user accounts

Modifying User Accounts

Modifying user accounts with Enterprise Manager

Modifying user accounts with Security Manager

Modifying user accounts with the ALTER USER command

Managing User Profiles

Managing profiles with Enterprise Manager

Managing profiles with Security Manager

Managing profiles with the CREATE PROFILE and ALTER PROFILE commands

Managing User Roles

Understanding the significance of roles

Managing roles with Enterprise Manager

Managing roles with Security Manager

Managing roles with the Command Line

This course is distributed with:

Simulations that allow users to practice course skills, even if they don't have access to the Oracle8 product

An Oracle8 glossary