Database Structures in Oracle9i

This course is included in our On-demand training solution.

Overview

To describe how to use an Oracle9i database data dictionary, the control files, and the redo log files

Target Audience

Anyone wanting to learn about Oracle9i database administration

Prerequisites

An understanding of database concepts and technologies

Expected Duration

140 min.

Course Objectives

Database Structures in Oracle9i

  • describe the contents of an Oracle9i database data dictionary and explain how to use it.
  • query an Oracle 9i database data dictionary to access information about an underlying database.
  • describe the purpose and content of an Oracle9i database control file and explain how to manage it.
  • multiplex an Oracle 9i database control file using the SPFILE.
  • describe the structure of the Oracle9i database redo log files and explain how they work and how to archive them.
  • describe how to manage redo log groups and members and how to obtain information about them.
  • add a new multiplexed log file to an Oracle9i database.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?