Supported and unsupported datatypes for replicating into and out of Oracle.
These SAP (formerly Sybase) datatypes are supported or unsupported by ExpressConnect for Oracle for replicating into Oracle.
Datatype |
Supported |
Unsupported |
---|---|---|
SAP (formerly Sybase) |
bigint |
bigdatetime |
integer |
bigtime |
|
smallint |
||
tinyint |
||
decimal |
||
numeric |
||
unsigned bigint |
||
unsigned integer |
||
unsigned smallint |
||
unsigned tinyint |
||
unichar |
||
univarchar |
||
unitext |
||
float |
||
double |
||
real |
||
money |
||
smallmoney |
||
date |
||
time |
||
datetime |
||
smalldatetime |
||
timestamp |
||
char |
||
nchar |
||
varchar |
||
nvarchar |
||
text |
||
binary |
||
varbinary |
||
image |
||
bit |
||
sysname (same as varchar(30)) |
||
longsysname (same as varchar(255)) |
||
user-defined datatypes (as underlying type) |
These Oracle datatypes are supported or unsupported by ExpressConnect for Oracle for replicating into Oracle.
Datatype |
Supported |
Unsupported |
---|---|---|
Oracle |
anydata (limited support) |
Associative array |
bfile (only for replication, not gateway) |
mlslabel |
|
binary_double |
Nested tables |
|
binary_float |
Oracle-supplied datatypes |
|
blob |
Partial large object (LOB) updates |
|
char |
ref |
|
clob |
User-defined datatypes (UDDs) containing LOBs |
|
date |
UDDs that are not final |
|
interval day to second |
urowid |
|
interval year to month |
varray |
|
long |
SecureFile LOBs |
|
long raw |
Oracle 11g xmltype |
|
nchar |
||
nclob |
||
number |
||
nvarchar2 |
||
raw |
||
rowid |
||
simple_integer |
||
timestamp |
||
timestamp with [local] time zone |
||
UDD object type (only for replication, not gateway) |
||
varchar2 |
||
Oracle 10g xmltype (limited support, handled as clob) |
These Oracle datatypes are supported or unsupported by Replication Agent for replicating out of Oracle.
Datatype |
Supported |
Unsupported |
---|---|---|
Oracle |
anydata (limited support) |
associative array |
binary_double |
bfile |
|
binary_float |
mlslabel |
|
blob |
nested tables |
|
char |
Oracle-supplied datatypes |
|
clob |
partial LOB updates |
|
date |
ref |
|
interval day to second |
UDDs containing LOB |
|
interval year to month |
UDDs that are not final |
|
long |
urowid |
|
long raw |
varray |
|
nchar |
||
nclob |
||
number |
||
nvarchar2 |
||
raw |
||
rowid |
||
simple_integer |
||
(Only if the your primary database is Oracle 11g Release 2 or later) SecureFile LOBs |
||
timestamp |
||
timestamp with [local] time zone |
||
UDD object type |
||
varchar2 |
||
xmltype (limited support, handled as clob) |
“ANY” types (SYS.ANYTYPE, SYS.ANYDATASET), except for SYS.ANYDATA.
Oracle 10g and 11g XMLType data replicated to Oracle 11g. Replication Agent does support replicating XMLType data to Oracle 10g.
Spatial types (MDSYS.SDO_GEOMETRY, SDO_TOPO_GEOMETRY, SDO_GEORASTER).
Media types (ORDSYS.ORDAudio, ORDSYS.ORDImage, ORDSYS.ORDImageSignature, ORDSYS.ORDVideo, ORDSYS.ORDDoc, SI_StillImage, SI_Color, SI_AverageColor, SI_ColorHistogram, SI_PositionalColor, SI_Texture, SI_FeatureList).
Expression filter type.
Replication from an ANYDATA column to a non-ANYDATA column.
ANYDATA size exceeding 16KB, which is the size constraint of the Replication Server OPAQUE datatype.
BFile, UROWID, REF, NESTED TABLE, and VARRAY datatypes stored in the ANYDATA column.
XMLType not stored as CLOB.
Replication of data stored in Oracle XML DB repository using standard protocols such as FTP and HTTP(S) or WebDAV, and other Oracle XML DB API
Marking procedures that use PLS_INTEGER PL/SQL type or any of its other subtypes; however, Replication Agent does support marking procedures that use SIMPLE_INTEGER PL/SQL type.
BFile
ROWID
XMLType object stored relationally or as a binary XML
“ANY” types (SYS.ANYTYPE, SYS.ANYDATASET)
Media types (ORDSYS.ORDAudio, ORDSYS.ORDImage, ORDSYS.ORDImageSignature, ORDSYS.ORDVideo, ORDSYS.ORDDoc, SI_StillImage, SI_Color, SI_AverageColor, SI_ColorHistogram, SI_PositionalColor, SI_Texture, SI_FeatureList)
Spatial types (MDSYS.SDO_GEOMETRY, SDO_TOPO_GEOMETRY, SDO_GEORASTER)
Uniform Resource Identifier (URI) Types