The following datatypes are supported with Oracle Change Selector.
|
CHAR |
VARCHAR2 |
NVARCHAR2 |
|
NCHAR |
NCLOB |
NUMBER |
|
INTEGER |
FLOAT |
DATE |
|
LONG |
CLOB |
BLOB |
|
LONG RAW |
|
|
The following are not supported: abstract datatypes, collections, object references, index organized tables and CREATE-SELECT combination.
Due to constraints with Oracle, Connect CDC cannot support the TIMESTAMP datatype as a distribution key. Additionally, if timestamp is chosen for standard replication, the fractional seconds are not included in the value at the target.