How To Setup Extended Data Support (EDS) to replicate changes made to a table with unsupported data types within the same database (Doc ID 873803.1)

Last updated on MARCH 13, 2024

Applies to:

Goal

Oracle Streams is a highly flexible feature of Oracle Database 10g that enables information sharing between databases. A primary capability of Oracle Streams is the ability to replicate information from one database to another.

There are, however, advanced datatypes available for use in the database that are not currently supported. Due to its high degree of flexibility, Oracle Streams provides the capability to replicate changes to some of these unsupported datatypes between databases with the use of Extended Datatype Support (EDS). In particular, the EDS package generates workaround scripts to support the replication of tables with the following datatypes:

• Object column with simple object types
• Object column with nested object types
• Varray
• Spatial type SDO_GEOMETRY
• XMLType 

This article is intended to assist Replication DBAs in setting up and configuring Oracle Streams Replication to replicate changes made to tables having unsupported data types. The article outlines the steps to set up replication for a table with an OBJECT DATA TYPE column from one SCHEMA to another SCHEMA in the same database using Extended Data Support (EDS). 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.