OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063), 2nd Edition

CHAPTER 17

Moving and Re-organizing Data

Exam Objectives

• 062.17.1    Describe Ways to Move Data

• 062.17.2    Create and Use Directory Objects

• 062.17.3    Use SQL*Loader to Load Data from a Non-Oracle Database

• 062.17.4    Use External Tables to Move Data via Platform-Independent Files

• 062.17.5    Explain the General Architecture of Oracle Data Pump

• 062.17.6    Use Data Pump Export and Import to Move Data between Oracle Databases

• 063.15.1    Use Data Pump in a Multitenant Environment

• 063.15.2    Use SQL*Loader in a Multitenant Environment

A common need in a database environment is to move data from one database to another. Oracle ...