TAILIEUCHUNG - Less18_MovingData_MB3

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 .

• Cơ sở dữ liệu
• workshopI
• oca 10g
• oracle
• database
• dba
• cơ sở dữ liệu
• công nghệ thông tin