Oracle Database 11g Release 2: Moving Data and Oracle Support


Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
From time to time Oracle DBAs are required to move data. Oracle Database 11g Release 2 offers various ways to complete this task, including Oracle Data Pump, SQL*Loader, and the use of external tables. DBAs are also required to ensure that the database is up-to-date with the latest patches and that critical errors are resolved, which includes contacting Oracle for support. This course explores how to move data using Data Pump Wizards or the command line. Working with the Enterprise Manager Support Workbench, My Oracle Support, service requests, and patch management are also covered. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle Database 11g: Administration I (1Z0-052) exam. Passing this exam will earn the learner Oracle Certified Associated (OCA).

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Expected Duration (hours)
1.5

Lesson Objectives

Oracle Database 11g Release 2: Moving Data and Oracle Support

  • identify the features of Oracle Data Pump
  • move data between Oracle Databases using Oracle Data Pump
  • use SQL*Loader to move data from external files into an Oracle Database
  • use external tables to access data in external sources
  • use Enterprise Manager Support Workbench to investigate, report, and resolve issues
  • work with My Oracle Support
  • manage patches
  • move data using the Data Pump
  • load data using SQL*Loader
  • use Support Workbench
  • Course Number:
    od_odas_a08_it_enus

    Expertise Level
    Intermediate