Title: Chapter 18 Moving Data
Course: RITA MC - ORACLE ADMINISTRATION I > Section: Unit 4 - Database Administration I

There are many situations where bulk transfers of data into a database or between
databases are necessary. Common cases are populating a data warehouse with data
extracted from transaction processing systems, or copying data from live systems to
test or development environments. As entering data with standard INSERT statements is not
always the best way to do large-scale operations, the Oracle database comes with facilities for
designed for bulk operations. These are SQL*Loader and Data Pump. There is also the possibility of
reading data without ever actually inserting it into the database; this is accomplished through use
of external tables.

Chapter 18 Learning Outcomes:

- Describe and Use Methods to Move Data (Directory Objects, SQL*Loader, External Tables)
- Ability to Explain the General Architecture of Oracle Data Pump
- Summarize how to Use Data Pump Export and Import to Move Data Between Oracle Databases

*Quizzes for Chapters 17 through 19 are all open until Exam 4 date.

One of the most important things to be successful in this course is to learn to navigate and locate assignments and information.  When in doubt, go to Modules!