Chapter 1: Oracle Architectural Components
- Using the Universal Installer
- Describing the Oracle Instance and The System Global Area
- Describing the Oracle Database Structure
Chapter 2: Oracle Tools
- Using SQL*Plus
- Using Oracle Enterprise Manager Tools
Chapter 3: Managing an Oracle Instance
- Creating and Modifying Initialization Parameter File
- Starting and Stopping Instance
- Opening and Closing a Database
- Monitoring ALERT Log and Trace Files
Chapter 4: Creating a Database
- Creating and Dropping a Database
- Creating Tablespaces
- Creating Users
Chapter 5: Data Dictionary Views and Standard Packages
- Creating the Data Dictionary
- Querying the Dictionary Views
- Creating the PL/SQL Environment
Chapter 6: Maintaing Control Files and Redo Logs
- Recreating and Relocating Control Files
- Creating Redo Log Groups and Members
- Dropping, Moving, and Renaming Redo Logs
- Querying the Data Dictionary for Information about Control Files and Redo Logs
Chapter 7: Managing Undo Data
- Understanding the Purpose of Undo Data
- Managing Undo Data
Chapter 8: Managing Tablespaces and Datafiles
- Planning File Locations to Optimize Database Performance
- Creating, Altering, Coalescing, and Dropping Tablespaces
- Adding, Renaming, and Relocating Datafiles
Chapter 9: Storage Structures and Relationships
- Describing the Logical Database Structure
- Understanding Block Space Use
- Understanding Row Chaining and Migration
- Querying the Data Dictionary for Information About Storage Structures and Relationships
Chapter 10: Managing Rollback and Temporary Segments
- Creating, Sizing, and Shrinking Rollback Segments
- Creating Temporary Tablespace
- Assigning Temporary Tablespace to Users
- Using Temporary Tablespaces
Chapter 11: Magaing Tables
- Creating, and Altering Tables
- Dropping and Truncating Tables
- Analyzing Tables
- Querying the Data Dictionary for Information about Tables
Chapter 12: Managing Indexes
- Selecting Correctly From Among Index Types
- Creating, Altering and Dropping Indexes
- Querying the Data Dictionary for Information about Indexes
Chapter 13: Maintaing Data Integrity
- Creating, Enabling, Disabling and Dropping Constraints
- Querying the Data Dictionary for Information about Data Integrity
Chapter 14: Loading and Reorganizing Data
- Using Conventional Path and Direct Path Loading
- Using the EXPORT and IMPORT Utilities
Chapter 15: Managing Users, Profiles, Roles, and Grants
- Creating, Altering, Dropping Users
- Creating and Using Profiles
- Using Password Verification
- Granting System and Object Privileges
- Creating and Using Roles
Chapter 16: Using Globalization Support
- Choosing Character Set and National Character Set for a Database
- Specifying the Language-Dependent Behavior
