Striim Migration Service for Google Cloud Documentation

Oracle to Cloud Spanner data type support and correspondence

SMSGC supports the following Oracle data types and converts them to the specified Spanner types.

Oracle type

Spanner type

BINARY_DOUBLE

FLOAT64

BINARY_FLOAT

FLOAT64

BLOB

BYTES

CHAR [(size [BYTE | CHAR])]

STRING

CLOB

STRING

DATE

DATE

FLOAT

FLOAT64

INT

INT64

INTEGER

INT64

INTERVAL DAY TO SECOND

STRING

INTERVAL YEAR TO MONTH

STRING

LONG

STRING

NCLOB

STRING

NCHAR[(size)]

STRING

NUMBER(P,S)

FLOAT64

NVARCHAR2(size)

STRING

RAW(size)

BYTES

TIMESTAMP [(fractional_seconds)]

TIMESTAMP

TIMESTAMP [(fractional_seconds)], WITH TIMEZONE

TIMESTAMP

TIMESTAMP [(fractional_seconds)] WITH LOCAL TIME ZONE

TIMESTAMP

VARCHAR2(size [BYTE | CHAR])

STRING

For more information, see Google's documentation of Spanner data types and Data validation constraints.

For assistance in migrating tables containing unsupported types, Contact SMSGC support.