My Oracle Support Banner

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:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


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). 


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Sample Code

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