SharePlex 10.2.1 - Installation and Setup Guide

Set up Oracle logging to support SharePlex Set up Oracle database objects for replication Set up an Oracle database to support SharePlex Set up SharePlex to support Oracle data Set up TDE Support

Set up replication from Oracle to a different target type

Set up replication from Oracle to MySQL Set up replication from Oracle to SQL Server Set up replication from Oracle to PostgreSQL Set up replication from Oracle to other Open Targets Set up replication from Oracle to JMS Set up replication from Oracle to a SQL or XML file

Generic SharePlex demonstration-all platforms

Prework for the demonstrations Start SharePlex Create and activate a configuration Demonstration of replication Demonstration of data compare and repair Demonstration of named post queues

Advanced SharePlex demonstrations for Oracle

Prework for the demonstrations Start SharePlex Configure, activate, and verify replication Demonstration of horizontally partitioned replication Demonstration of vertically partitioned replication Demonstration of transformation Demonstration of conflict resolution Demonstration of Oracle DDL replication

Solve Installation Problems

Solve license utility problems Solve installer problems Solve database setup problems Solve database connection problems Solve SharePlex startup problems Solve sp_ctrl problems Solve host connection problems How to find the ORACLE_SID and ORACLE_HOME

Database Setup Utilities

MySQL Setup (mysql_setup) Oracle Setup (ora_setup) PostgreSQL Setup (pg_setup) SQL Server Setup (mss_setup)

General SharePlex Utilities

SharePlex license utilities Install the SharePlex service

Uninstall SharePlex

Uninstall SharePlex from Windows

SharePlex installed items

Map source and target columns

When source and target column names are different, you can specify an explicit column mapping in the configuration file, to ensure that Post applies row data to the correct target columns.

Guidelines for using column mapping

To use column mapping, you must map every column in a source table to a column in the target table, even if only some source and target names are different. When some columns are mapped but not others, the entry is considered to be a column partition for vertically partitioned replication, and data changes for non-listed columns are not replicated.
If the spelling case is different between the source and target column names, enclose them within quotes.
You can use horizontally partitioned replication and column mapping for the same source table, but you cannot combine column mapping with vertically partitioned replication.
A target table can have more columns than the source table, but there must at least be a target column for every source column.
ALTER TABLE to add a column to a table that is configured with column mapping is not supported.

Configure column mapping

The following syntax creates a column map. For more information, see Configure data replication.

datasource_specification
src_owner.table (src_col,src_col,...)	tgt_owner.table (tgt_col,tgt_col,...)	routing_map

Configuration component	Description
datasource_specification	The datasource specification. For more information, see Database specifications in a configuration file.
src_owner.table and tgt_owner.table	The specifications for the source and target tables, respectively. For more information, see Create a configuration file.
(src_col,src_col,...)	A list of the source columns. Follow these rules to specify a column list: A column list must be enclosed within parentheses. Separate each column name with a comma. A space after the comma is optional. The maximum length of a column list is 174820 bytes (the maximum line length allowed in a configuration file).
(tgt_col,tgt_col,...)	A list of the target columns. List the target columns in the same logical order as their corresponding source columns. This is required regardless of the actual order of the target columns in the table, so that SharePlex builds the correct map in the object cache. For example, a change to the second column in the source list is replicated to the second column in the target list. The syntax rules for the source list also apply to the target list.
routing_map	The routing map. For more information, see Routing specifications in a configuration file.

Configuration example

This example contains no case-sensitive columns.

Datasource o.oraA
sales.prod (ID,name,vendor)	mfg.prod (UPC,product,supplier)	sysB@o.oraB

This example contains case-sensitive columns.

Datasource o.oraA
sales.prod (ID,"name",vendor)	mfg.prod (UPC,"product",supplier)	sysB@o.oraB

请选择您的产品：

为向您提供更好的服务，请填写'Purpose of your Chat'（联系目的）：

针对您的问题建议的解决方案

SharePlex 10.2.1 - Installation and Setup Guide

Map source and target columns

Guidelines for using column mapping

Configure column mapping

Configuration example