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>;
