Managing Database Objects in Oracle Database 10g

Overview/Description
To demonstrate how to create external tables and to use the data dictionary views in Oracle 10g

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with RDBMS technologies and programming techniques

Expected Duration
110 Minutes

Objectives:

Managing Database Objects in Oracle Database 10g

  • create external tables and identify how to query them.
  • create and query external tables in Oracle 10g.
  • view information about user objects, tables, and columns using data dictionary views.
  • query the dictionary views for object, table, and column information.
  • view information about constraints, views, sequences, synonyms, and comments using data dictionary views.
  • query the data dictionary view for information about constraints, views, sequences, synonyms, and comments.


    • Course Number: 223296_eng