Saturday, December 11, 2010

Oracle Golden Gate supported data types

Oracle GoldenGate Supported data types
Numeric data types
● NUMBER up to the maximum size permitted by Oracle
● BINARY FLOAT
● BINARY DOUBLE
Character data types
● CHAR
● VARCHAR2
● LONG
● NCHAR
● NVARCHAR2
Multi-byte character types
● NCHAR and NVARCHAR2 multi-byte character data types
● Multi-byte data stored in CHAR and VARCHAR2 columns
Binary data types
● RAW
● LONG RAW
Date and timestamp data types
● DATE
● TIMESTAMP (see non-supported data types for exclusions)
Large object data types
● CLOB
● NCLOB
● BLOB
XML data types
● XMLType is supported.
User defined types
Oracle GoldenGate supports user defined types (UDT) when the source and target objects
have the same structure. The schema names can be different.
Other supported data types
● ROWID
● VARRAY
● INTERVAL DAY and INTERVAL YEAR if the size of the target column is equal to, or greater than,
that of the source.

No comments:

Post a Comment