4，在源端，使用ADD EXTTRAIL命令來創建一個本地trail ADD EXTTRAIL <local_trail>, EXTRACT <ext> 使用參數EXTRACT將提取組ext和trail相鏈接。提取組將信息寫入trail，投遞組從trail中讀取。 5，在源端，使用EDIT PARAMS命令為初級提取組創建一個參數文件。 -- Identify the Extract group:EXTRACT <ext>
-- Specify database login information as needed for the database:
[SOURCEDB <dsn_1>][, USERID <user>][, PASSWORD <pw> [<encryption options>]] -- Specify the local trail that this Extract writes to
-
- and encryption options:
ENCRYPTTRAIL <encryption options>EXTTRAIL <local_trail>
-- Specify tables to be captured:
TABLE <owner>.<table>;
EXTTRAIL用于指定本地trail
配置數據泵投遞組 在源頭端，使用ADD EXTRACT 命令為每一個目標系統創建數據泵。在這里我們取名為pump_1，pump2. ADD EXTRACT <pump_1>, EXTTRAILSOURCE <local_trail>, BEGIN <time> ADD EXTRACT <pump_2>, EXTTRAILSOURCE <local_trail>, BEGIN <time> EXTRACT參數用于將遠程trail連接到不同的投遞組。被指定的投遞組將信息寫入相對應的trail文件。 8，在源端，使用EDIT PARAMS命令為每一個數據泵提取組創建參數文件。 Data pump_1
-- Identify the data pump group:
EXTRACT <pump_1>
-- Specify database login information if using NOPASSTHRU:
[SOURCEDB <dsn_1>][, USERID <user>][, PASSWORD <pw> [<encryption options>]] -- Specify decryption options if input trail is encrypted.DECRYPTTRAIL
<encryption options>
-- Specify the name or IP address of the first target system
-- and optional encryption of data over TCP/IP:
RMTHOST <target_1>, MGRPORT <portnumber>, ENCRYPT <encryption options>
-- Specify remote trail and encryption options on first target system:
ENCRYPTTRAIL <encryption options>
RMTTRAIL <remote_trail_1>
-- Allow mapping, filtering, conversion or pass data through as-is:
[PASSTHRU | NOPASSTHRU]
-- Specify tables to be captured:
TABLE <owner>.<table>;
Data pump_2
-- Identify the data pump group:
EXTRACT <pump_2>-- Specify database login information if using NOPASSTHRU:
[SOURCEDB <dsn_1>][, USERID <user>][, PASSWORD <pw> [<encryption options>]] -- Specify decryption options if input trail is encrypted.DECRYPTTRAIL
<encryption options>
-- Specify the name or IP address of the second target system
-- and optional encryption of data over TCP/IP:
RMTHOST <target_2>, MGRPORT <portnumber>, ENCRYPT <encryption options>
-- Specify remote trail and encryption options on second target system:
ENCRYPTTRAIL <encryption options>RMTTRAIL <remote_trail_2>
-- Allow mapping, filtering, conversion or pass data through as-is:
[PASSTHRU | NOPASSTHRU]
-- Specify tables to be captured:
TABLE <owner>.<table>;
