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