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 |
|