Oracle CDC Instance Data Types
Important
Change Data Capture for Oracle by Attunity is deprecated now. For details, refer to the announcement.
The Oracle CDC Instance supports most Oracle data types. The following sections describe the supported data types and the non-supported data types.
Supported Data Types
The following table describes the Oracle data types that can be captured and their default mapping to SQL Server data types in the change tables. When adding a capture instance for a source Oracle table, you can override some of these mappings.
Oracle Database Data Type | SQL Server Data Type |
---|---|
BINARY_FLOAT | REAL |
BINARY_DOUBLE | FLOAT |
CHAR | NVARCHAR |
DATE | DATETIME |
FLOAT | FLOAT |
INT | NUMERIC (38) |
INTERVAL | DATETIME |
NCHAR | NVARCHAR |
NUMBER | FLOAT |
NAVARCHAR2 | NVARCHAR |
RAW | VARBINARY |
REAL | FLOAT |
TIMESTAMP | DATETIME2 |
TIMESTAMP WITH TIME ZONE | VARCHAR (37) |
TIMESTAMP WITH LOCAL TIME ZONE | VARCHAR (37) |
VARCHAR2 | VARCHAR |
XMLTYPE | NVARCHAR (MAX) |
Non-Supported Data Types
Source Oracle tables with columns of the following Oracle data types cannot be captured. Captured columns with these data types will show as null; however, a change in their value is indicated in the change mask of the captured tables.
LONG
XMLTYPE
BLOB
CLOB
Source Oracle tables with columns of the following Oracle data types cannot be captured.
BFILE
ROWID
REF
UROWID
Nested Table
If the following data types are present in a table they will prevent the LogMinder from getting any data for any column of the table:
User-defined data types
VARRAY
See Also
Change Data Capture Designer for Oracle by Attunity
The Oracle CDC Instance
משוב
https://aka.ms/ContentUserFeedback.
בקרוב: במהלך 2024, נפתור בעיות GitHub כמנגנון המשוב לתוכן ונחליף אותו במערכת משוב חדשה. לקבלת מידע נוסף, ראה:שלח והצג משוב עבור