第18章 Moving Data

certification objectives:

• Describe and Use Methods to Move Data(Directory Objects,SQL*Loader,External Tables)
• Explain the General Architecture of Oracle Data Pump

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 alse the possibility of reading data without ever actually inserting it into the database;this is accomplished through use external tables.

 

Describe and Use Methods to Move Data(SQL Loader,Directory Objects,External Tables)