- Part I Oracle Data Pump. - 1 Overview of Oracle Data Pump. - Data Pump Components. - 1-1 What New Features Do Data Pump Export and Import Provide. - 1-2 How Does Data Pump Access Data. - 1-16 Original Export and Import Versus Data Pump Export and Import. - 2 Data Pump Export. - What Is Data Pump Export. - 2-1 Invoking Data Pump Export. - 2-2 Data Pump Export Interfaces. - 2-3 Data Pump Export Modes. - 2-34 How Data Pump Export Parameters Map to Those of the Original Export Utility. - 2-42 Examples of Using Data Pump Export. - 2-45 Syntax Diagrams for Data Pump Export. - 3 Data Pump Import. - What Is Data Pump Import. - 3-1 Invoking Data Pump Import. - 3-2 Data Pump Import Interfaces. - 3-2 Data Pump Import Modes. - 3-41 How Data Pump Import Parameters Map to Those of the Original Import Utility. - Examples of Using Data Pump Import. - 3-50 Syntax Diagrams for Data Pump Import. - 4 Data Pump Performance. - Data Performance Improvements for Data Pump Export and Import. - 5 The Data Pump API. - How Does the Client Interface to the Data Pump API Work. - 5-4 Examples of Using the Data Pump API. - 1-10 1–2 The DBA_DATAPUMP_SESSIONS View. - Chapter 2, "Data Pump Export". - Chapter 3, "Data Pump Import". - Chapter 5, "The Data Pump API". - Data Pump Technology. - Data Pump Export. - See Chapter 2, "Data Pump Export". - Data Pump Import. - Data Pump API. - Oracle Data Pump. - Overview of Oracle Data Pump. - What New Features Do Data Pump Export and Import Provide?. - How Does Data Pump Access Data?. - Original Export and Import Versus Data Pump Export and Import. - Most Data Pump export and import operations occur on the Oracle database server. - Data Pump technology enhances direct path technology in the following ways:. - In the following circumstances, Data Pump cannot use direct path loading:. - Data Pump uses external tables as the data access mechanism in the following situations:. - Table 1–2 The DBA_DATAPUMP_SESSIONS View. - %setenv DATA_PUMP_DIR DUMP_FILES1. - You would then use the following Data Pump Export command:. - DIRECTORY on page 2-10 for information about using this parameter in Data Pump Export. - If you are familiar with the original Export ( exp ) and Import ( imp ) utilities, it is important to understand that many of the concepts behind them do not apply to Data Pump Export ( expdp ) and Data Pump Import ( impdp. - Data Pump Export and Import represent metadata in the dump file set as XML documents rather than as DDL commands. - Data Pump Export and Import are self-tuning utilities. - How Data Pump Export Parameters Map to Those of the Original Export Utility on page 2-35. - How Data Pump Import Parameters Map to Those of the Original Import Utility on page 3-42. - This chapter describes the Oracle Data Pump Export utility. - What Is Data Pump Export?. - Invoking Data Pump Export. - How Data Pump Export Parameters Map to Those of the Original Export Utility. - Examples of Using Data Pump Export. - Syntax Diagrams for Data Pump Export. - The Data Pump Export utility is invoked using the expdp command. - Data Pump Export Interfaces on page 2-3. - Data Pump Export Modes on page 2-3. - Data Pump Export Interfaces. - Data Pump Export Modes. - See Also: Examples of Using Data Pump Export on page 2-43. - This section provides descriptions of the parameters available in the command-line mode of Data Pump Export. - Examples of Using Data Pump Export on page 2-43. - The following is an example of using the default DATA_PUMP_DIR directory object available to privileged users. - Note: Data Pump Export writes the log file using the database character set. - performance of the job. - Table 2–2 Supported Activities in Data Pump Export's Interactive-Command Mode. - The following are descriptions of the commands available in the interactive-command mode of Data Pump Export.. - Provides information about Data Pump Export commands available in. - This section provides the following examples of using Data Pump Export:. - This chapter describes the Oracle Data Pump Import utility. - What Is Data Pump Import?. - Invoking Data Pump Import. - How Data Pump Import Parameters Map to Those of the Original Import Utility. - Syntax Diagrams for Data Pump Import. - The Data Pump Import utility is invoked using the impdp command. - Data Pump Import Interfaces on page 3-2. - Data Pump Import Modes on page 3-3. - Data Pump Import Interfaces. - Data Pump Import Modes. - This section provides descriptions of the parameters available in the command-line mode of Data Pump Import. - Examples of Using Data Pump Import on page 3-49. - (See PARALLEL on page 2-25.) The names of the dump files are par_exp01.dmp , par_exp02.dmp , and par_exp03.dmp . - (See DUMPFILE on page 2-12.) The import job looks for the exp1.dmp file in the location pointed to by dpump_dir2 . - The following are descriptions of the commands available in the interactive-command mode of Data Pump Import.. - Table 3–2 Supported Activities in Data Pump Import's Interactive-Command Mode. - Provides information about Data Pump Import commands available in interactive-command mode.. - This section provides examples of the following ways in which you might use Data Pump Import:. - Data Pump Performance. - The improved performance of the Data Pump Export and Import utilities is attributable to several factors, including the following:. - The Data Pump API. - How Does the Client Interface to the Data Pump API Work?. - Examples of Using the Data Pump API. - for additional explanation of Data Pump concepts. - This example shows a simple schema export using the Data Pump API
Xem thử không khả dụng, vui lòng xem tại trang nguồn hoặc xem
Tóm tắt