- 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. - SQL*Loader Data Pump - Export - Import. - Data Pump DBMS_DATAPUMP. - Data/Metadata Movement Engine SQL*Loader. - SQL*Loader: Overview Directory Obj.. - Input data files Control file SQL*Loader. - SQL*Loader Overview Full Notes Page. - Loading Data with SQL*Loader. - SQL*Loader Control File. - The SQL*Loader control file instructs SQL*Loader about:. - SQL*Loader Control File Full Notes Page. - Data Pump: Overview. - As a server-based facility for high-speed data and metadata movement, data pump:. - External tables. - Restarts Data Pump jobs. - SQL*Loader. - Data Pump - Export - Import. - Data Pump: Benefits. - Data Pump Export and Import: Overview. - Data Pump job Source. - Data Pump job impdp. - Data Pump Utility: Interfaces and Modes. - Data Pump Export and Import interfaces:. - Data Pump Export and Import modes:. - SQL*Loader Data Pump. - expdp hr/hr DIRECTORY=DATA_PUMP_DIR DUMPFILE=sample1.dmp SAMPLE=30. - Data Pump File Locations. - The DATA_PUMP_DIR environment variable. - DATA_PUMP_DIR directory object. - Data Pump Files Location Full Notes Page. - Data Pump File Naming and Size. - Data Pump Import Directory Obj.. - SQL*Loader Data Pump - Export. - Data Pump Import: Transformations. - Data Pump: Performance Consideration. - Performance of Data Pump can be affected by:. - Data Pump Access Path: Considerations. - One of the following access paths is automatically selected by Data Pump:. - Using Enterprise Manager to Monitor Data Pump Jobs. - Using External Tables. - [DBA| ALL| USER]_EXTERNAL_TABLES. - Using the Data Pump Export Wizard to select database objects to be exported. - Monitoring a Data Pump Export job. - Using the Data Pump Import Wizard to import tables in your database
Xem thử không khả dụng, vui lòng xem tại trang nguồn hoặc xem
Tóm tắt