Home > Training > Database Architecture & Admin. > Page 2 > Page 3

Oracle8i Database Architecture & Administration

Course Topics Contd... Page3

Managing Indexes
Listing the Different Types of Indexes and Their Uses
Creating B*-Tree and Bitmap Indexes
Reorganizing Indexes
Dropping Indexes
Getting Index Information from the Data Dictionary

Maintaining Data Integrity
Implementing Data Integrity
Maintaining Integrity Constraints
Obtaining Constraint Information from the Data Dictionary

Loading Data
Loading Data Using Direct-Load Insert
Loading Data into Oracle Tables Using SQL*Loader
Conventional
Direct Paths

Reorganizing Data
Reorganizing Data Using Export and Import
Moving Data Using Transportable Tablespaces

Managing Password Security and Resources
Managing Passwords Using Profiles
Administering Profiles
Controlling Use of Resources Using Profiles
Obtaining Information About Profiles, Password Management, and Resources

Managing Users
Creating New Database Users
Altering and Dropping Existing Database Users
Monitoring Information About Existing Users

Managing Privileges
Identifying System and Object Privileges
Granting and Revoking Privileges
Controlling Operating System or Password File Authentication
Identifying Auditing Capabilities

Managing Roles
Creating and Modifying Roles
Controlling Availability of Roles
Removing Roles
Using Predefined Roles
Displaying Role Information from the Data Dictionary

Suggested Next Courses:

Oracle8i Database Backup & Recovery

Back <<