Tables and Indexes in Oracle9i

Overview/Description
To describe how to manage tables and indexes in an Oracle9i database

Target Audience


Anyone wanting to learn about Oracle9i database administration

Prerequisites


An understanding of database concepts and technologies

Expected Duration


180 Minutes

Objectives :

Tables and Indexes in Oracle9i

  • describe the various methods used to store user data in an Oracle9i database.
  • describe the various datatypes used in an Oracle9i database.
  • describe how to create tables in an Oracle9i database.
  • create a table in an Oracle9i database.
  • describe the classification of indexes and their types in an Oracle9i database.
  • describe how to create normal B-tree and bitmap indexes in an Oracle9i database.
  • describe how to manage indexes in an Oracle9i database.
  • create an index in an Oracle9i database.
  • rebuild or coalesce an index in an Oracle9i database.


    • Course Number: 59296_eng