This topic describes the incompatibilities between an Oracle database and an Oracle-compatible tenant of OceanBase Database in changing the data type of an unconstrained column.
Note
- In the following tables, the supported target types of columns in Oracle-compatible 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-compatible 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-compatible 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 | - |
