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

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

Prerequisite
Please contact us for information about prerequisites.

Expected Duration
90 minutes

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).

Objective

Moving Data

  • 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
  • Support and Patching

  • 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
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.