This topic describes the incompatibilities between an Oracle database and an Oracle tenant of OceanBase Database in changing the length of an unconstrained column.
The following table describes the incompatibilities between an Oracle database and an Oracle tenant of OceanBase Database in changing the length of a column by using the ALTER TABLE table_name MODIFY DDL statement.
In the table, a hyphen (-) indicates none.
Column type in Oracle database | Allowed operation | Column type in Oracle tenant of OceanBase Database | Allowed operation |
INTEGER | - | NUMBER(38,0) | - |
INT | - | NUMBER(38,0) | - |
SMALLINT | - | NUMBER(38,0) | - |
BINARY_FLOAT | - | BINARY_FLOAT | - |
BINARY_DOUBLE | - | BINARY_DOUBLE | - |
DECIMAL | Increase and decrease the length | NUMBER | Increase the length |
DEC | Increase and decrease the length | NUMBER | Increase the length |
NUMERIC | Increase and decrease the length | NUMBER | Increase the length |
REAL | Increase and decrease the length | NUMBER | Increase the length |
DOUBLE | Increase and decrease the length | NUMBER | Increase the length |
FLOAT | Increase and decrease the length | FLOAT | Increase the length |
NUMBER | Increase and decrease the length | NUMBER | Increase the length |
NCHAR | Increase and decrease the length | NCHAR | Increase the length |
CHAR | Increase and decrease the length | CHAR | Increase the length |
CHARACTER | Increase and decrease the length | CHAR | Increase the length |
NVARCHAR2 | Increase and decrease the length | NVARCHAR2 | Increase the length |
VARCHAR2 | Increase and decrease the length | VARCHAR2 | Increase the length |
VARCHAR | Increase and decrease the length | VARCHAR2 | Increase the length |
RAW | Increase and decrease the length | RAW | Increase the length |
LONG | - | CLOB | - |
LONG RAW | - | BLOB | - |
ROWID | - | ROWID | - |
UROWID | - | UROWID | - |
TIMESTAMP | Increase and decrease the length | TIMESTAMP | Increase the length |
TIMESTAMP WITH TIME ZONE | Increase and decrease the length | TIMESTAMP WITH TIME ZONE | Increase and decrease the length |
TIMESTAMP WITH LOCAL TIME ZONE | Increase and decrease the length | TIMESTAMP WITH LOCAL TIME ZONE | Increase and decrease the length |
DATE | - | DATE | - |
INTERVAL YEAR TO MONTH | Increase and decrease the length | INTERVAL YEAR TO MONTH | Increase and decrease the length |
INTERVAL DAY TO SECOND | Increase and decrease the length | INTERVAL DAY TO SECOND | Increase and decrease the length |
BLOB | - | BLOB | - |
CLOB | - | CLOB | - |
NCLOB | - | CLOB | - |