Go BackOracle8: Building Databases

Synopsis
Oracle8: Building Databases shows users how to create and set up new Oracle databases.

Audience
This course is for anyone who is interested in learning about designing and building databases and tablespaces in the Oracle environment.

Time
6 hours

Product Code: ORCC03
After completing Oracle8: Building Databases, the user should be able to:
 
Plan and design a database
Prepare for a new database
Create a new database and catalog
Modify a database
Create and modify tablespaces
Manage tablespaces

Database Planning and Design
 
Understanding the process of creating a database
Designing a database

Creating a New Database and Catalogs
 
Creating a database
Creating catalogs

Modifying Databases
 
Modifying with the Enterprise Manager
Modifying with DDL statements
Monitoring databases

Creating Tablespaces
 
Creating tablespaces with Enterprise Manager
Creating tablespaces with Storage Manager

Modifying Tablespaces
 
Bringing a tablespace offline
Modifying a tablespace for backup
Adding datafiles
Altering tablespace properties

Managing Tablespaces
 
Using the storage clause
Making a tablespace read-only
Creating a temporary tablespace
Monitoring tablespaces

This course is distributed with:
 
Exercises that allow users to practice in Oracle8
A file containing the text of the exercises
Simulations that allow users to practice course skills, even if they don't have access to the Oracle8 product
An Oracle8 glossary


 

Go Back