This topic describes the incompatibilities between an Oracle database and an Oracle-compatible 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-compatible tenant of OceanBase Database in changing the length of a column by using the ALTER TABLE table_name MODIFY DDL statement.
Note
In the table, a hyphen (-) indicates none.
Column type in Oracle database |
Allowed operation |
Column type in Oracle-compatible 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 | - |