This topic describes the incompatibilities between an Oracle database and an Oracle tenant of OceanBase Database in changing the data type of an unconstrained column.
In the following tables, the supported target types of columns in Oracle tenants of OceanBase Database are results of type mapping.
In the following tables, a hyphen (-) indicates none and 'All' indicates all types.
The following table describes the incompatibilities between an Oracle database and an Oracle tenant of OceanBase Database in changing the type of a column by using the ALTER TABLE table_name MODIFY DDL statement.
Column type in Oracle database | Supported target type other than the original type | Column type in Oracle tenant of OceanBase Database | Supported target type other than the original type |
INTEGER | All types except for BLOB, CLOB, and NCLOB | NUMBER(38,0) | - |
INT | All types except for BLOB, CLOB, and NCLOB | NUMBER(38,0) | - |
SMALLINT | All types except for BLOB, CLOB, and NCLOB | NUMBER(38,0) | - |
BINARY_FLOAT | All types except for BLOB, CLOB, and NCLOB | BINARY_FLOAT | - |
BINARY_DOUBLE | All types except for BLOB, CLOB, and NCLOB | BINARY_DOUBLE | - |
DECIMAL | All types except for BLOB, CLOB, and NCLOB | NUMBER | - |
DEC | All types except for BLOB, CLOB, and NCLOB | NUMBER | - |
NUMERIC | All types except for BLOB, CLOB, and NCLOB | NUMBER | - |
REAL | All types except for BLOB, CLOB, and NCLOB | NUMBER | - |
FLOAT | All types except for BLOB, CLOB, and NCLOB | FLOAT | - |
NUMBER | All types except for BLOB, CLOB, and NCLOB | NUMBER | - |
NCHAR | All types except for BLOB, CLOB, and NCLOB | NCHAR | - |
CHAR | All types except for BLOB, CLOB, and NCLOB | CHAR | - |
CHARACTER | All types except for BLOB, CLOB, and NCLOB | CHAR | - |
NVARCHAR2 | All types except for BLOB, CLOB, and NCLOB | NVARCHAR2 | - |
VARCHAR2 | All types except for BLOB, CLOB, and NCLOB | VARCHAR2 | - |
VARCHAR | All types except for BLOB, CLOB, and NCLOB | VARCHAR2 | - |
RAW | All types except for BLOB, CLOB, and NCLOB | RAW | - |
LONG | All types except for BLOB, CLOB, and NCLOB | CLOB | - |
LONG RAW | All types except for BLOB, CLOB, and NCLOB | BLOB | - |
ROWID | All types except for BLOB, CLOB, and NCLOB | ROWID | UROWID |
UROWID | All types except for BLOB, CLOB, and NCLOB | UROWID | ROWID |
TIMESTAMP | All types except for BLOB, CLOB, and NCLOB | TIMESTAMP | - |
TIMESTAMP WITH TIME ZONE | All types except for BLOB, CLOB, and NCLOB | TIMESTAMP WITH TIME ZONE | - |
TIMESTAMP WITH LOCAL TIME ZONE | All types except for BLOB, CLOB, and NCLOB | TIMESTAMP WITH LOCAL TIME ZONE | - |
DATE | All types except for BLOB, CLOB, and NCLOB | DATE | - |
INTERVAL YEAR TO MONTH | All types except for BLOB, CLOB, and NCLOB | INTERVAL YEAR TO MONTH | - |
INTERVAL DAY TO SECOND | All types except for BLOB, CLOB, and NCLOB | INTERVAL DAY TO SECOND | - |
BLOB | - | BLOB | - |
CLOB | - | CLOB | - |
NCLOB | - | CLOB | - |