Supported Teradata Data Types

The following table shows the Teradata data types that Oracle GoldenGate supports. Any limitations or conditions that apply follow this table.

Data type v15.x v16.x

BLOB

Yes

Yes

BYTEINT

Yes

Yes

VARBYTE

Yes

Yes

BIGINT

Yes

Yes

BYTEINT

Yes

Yes

DATE

Yes

Yes

DECIMAL - 18 and under

Yes

Yes

DECIMAL - 19 to 38

Yes

Yes

DOUBLE PRECISION

Yes

Yes

FLOAT

Yes

Yes

INTEGER

Yes

Yes

NUMERIC - 18 and under

Yes

Yes

NUMERIC - 19 to 38

Yes

Yes

REAL

Yes

Yes

SMALLIINT

Yes

Yes

TIME

Yes

Yes

TIMESTAMP

Yes

Yes

INTERVAL

Yes

Yes

INTERVAL DAY

Yes

Yes

INTERVAL DAY TO HOUR

Yes

Yes

INTERVAL DAY TO MINUTE

Yes

Yes

INTERVAL DAY TO SECOND

Yes

Yes

INTERVAL HOUR

Yes

Yes

INTERVAL HOUR TO MINUTE

Yes

Yes

INTERVAL HOUR TO SECOND

Yes

Yes

INTERVAL MINUTE

Yes

Yes

INTERVAL MINUTE TO SECOND

Yes

Yes

INTERVAL MONTH

Yes

Yes

INTERVAL SECOND

Yes

Yes

INTERVAL YEAR

Yes

Yes

INTERVAL YEAR TO MONTH

Yes

Yes

CHAR

Yes

Yes

CLOB

Yes

Yes

CHAR VARYING

Yes

Yes

LONG VARCHAR

Yes

Yes

VARCHAR

Yes

Yes

GRAPHIC

Yes

Yes

LONG VARGRAPHIC

Yes

Yes

VARGRAPHIC

Yes

Yes

PERIOD (DATE)

Yes

Yes

PERIOD (TIME)

Yes

Yes

PERIOD (TIMESTAMP)

Yes

Yes

UDT

Yes

Yes