After completing this lesson, you should be able to do the following: • Describe available ways for moving data • Create and use directory objects • Use SQL*Loader to load data from a non-Oracle database (or user files) • Explain the general architecture of Data Pump • Use Data Pump Export and Import to move data between Oracle databases • Use external tables to move data via platform- independent files | Moving Data Objectives After completing this lesson, you should be able to do the following: Describe available ways for moving data Create and use directory objects Use SQL*Loader to load data from a non-Oracle database (or user files) Explain the general architecture of Data Pump Use Data Pump Export and Import to move data between Oracle databases Use external tables to move data via platform-independent files Directory Obj. SQL*Loader Data Pump - Export - Import External Table Moving Data: General Architecture External Table API Oracle loader Oracle DataPump Direct Path API Metadata API expdp impdp Other clients Data Pump DBMS_DATAPUMP Data/Metadata Movement Engine SQL*Loader Moving Data: General Architecture This is a block diagram of the major functional components: DBMS_DATAPUMP: This package embodies the API for high-speed export and import utilities for bulk data and metadata movement. Direct Path API (DPAPI): Oracle Database 10g supports a direct path API interface that . | Moving Data Objectives After completing this lesson, you should be able to do the following: Describe available ways for moving data Create and use directory objects Use SQL*Loader to load data from a non-Oracle database (or user files) Explain the general architecture of Data Pump Use Data Pump Export and Import to move data between Oracle databases Use external tables to move data via platform-independent files Directory Obj. SQL*Loader Data Pump - Export - Import External Table Moving Data: General Architecture External Table API Oracle loader Oracle DataPump Direct Path API Metadata API expdp impdp Other clients Data Pump DBMS_DATAPUMP Data/Metadata Movement Engine SQL*Loader Moving Data: General Architecture This is a block diagram of the major functional components: DBMS_DATAPUMP: This package embodies the API for high-speed export and import utilities for bulk data and metadata movement. Direct Path API (DPAPI): Oracle Database 10g supports a direct path API interface that minimizes data conversion and parsing at both unload and load time. DBMS_METADATA: This package is used by worker processes for all metadata unloading and loading. Database object definitions are stored using XML rather than SQL. External Table API: With the ORACLE_DATAPUMP and ORACLE_LOADER access drivers, you can store data in external tables (that is, in platform-independent files). The SELECT statement reads external tables as though they were stored in an Oracle database. SQL*Loader: The SQL*Loader client has been integrated with external tables, thereby providing automatic migration of loader control files to external table access parameters. expdp and impdp: The expdp and impdp clients are thin layers that make calls to the DBMS_DATAPUMP package to initiate and monitor Data Pump operations. Other clients: They are applications, such as Database Control, replication, transportable tablespaces, and user applications, that benefit from this infrastructure. SQL*Plus may also be used as
