Data Type Support for GoldenGate 11.1.1.1

This blog post shows what is supported / Unsupported in Goldengate 11.1.1 Replication

Below are the supported and unsupported data types in Goldengate 11.1.1 for Oracle databases. These are the basic limitations that must be taken into consideration when configuring replication using Goldengate.

DATA TYPES

Supported GoldenGate Oracle Data Types

NUMBER
BINARY FLOAT
BINARY DOUBLE
CHAR
VARCHAR2
LONG
NCHAR
NVARCHAR2
RAW
LONG RAW

CLOB
NCLOB
BLOB
XML data types
User defined types (UDT)

DATE

TIMESTAMP

TIMESTAMP with TIMEZONE

Non-Supported Goldengate Oracle Data Types
ORDDICOM
ANYDATA
ANYDATASET
ANYTYPE
BFILE
MLSLABEL
TIMEZONE_ABBR
TIMEZONE_REGION
URITYPE
UROWID
DDL REPLICATION SUPPORT

Support for DDL on objects:
TABLES
INDEX
TRIGGERS
SEQUENCES
MATERIALIZED VIEWS
VIEWS
FUNCTION
PACKAGES
PROCEDURE
SYNONYMS
PUBLIC SYNONYMS

DDL On ALL Oracle Reserved Schemas is unsupported.
These include:
ANONYMOUS
AURORA
$JIS
$UTILITY
$AURORA
$ORB
$UNAUTHENTICATED
CTXSYS
DBSNMP
DMSYS
DSSYS
EXFSYS
MDSYS
ODM
ODM_MTR
OLAPSYS
ORDPLUGINS
ORDSYS
OSE$HTTP$ADMIN
OUTLN
PERFSTAT
PUBLIC
REPADMIN
SYS
SYSMAN
SYSTEM
TRACESVR
WKPROXY
WKSYS
WMSYS
XDB

ADDITIONAL UNSUPPORTED OBJECTS TO WATCH OUT FOR:

External tables are not supported
Compressed tables are not supported
TDE at column and tablespace level is supported. Check out Release guide for more information.

http://en.wikipedia.org/wiki/Goldengate