MySQL [test]> alter table t2 modify column id varchar(32); ERROR 1235 (0A000): Alter non string type not supported 暂不支持后面再调整字段顺序,仅新建字段时支持调整顺序。 MySQL [test]> alter table t1 add column `time` date default null; Query OK, 0 rows affected (0.021 sec) MySQL ...
OceanBase 不允许修改非字符类型和修改列定义,仅支持增加特定字符数据类型(VARCHAR、VARBINARY、CHAR等)的长度。 alter table hjjtesttable modify testyxj7 bigint COMMENT 'test'; ERROR 1235 (0A000): Alter non string type not supported 场景五:创建索引。 OceanBase 创建索引,增量同步正常;MySQL 创建索引,增量...
本文为您介绍迁移 Oracle 数据库的数据至 OceanBase 数据库 Oracle 租户时, ALTER TABLE DDL 修改、删除和新增表属性的支持转换范围。 总览 alter_table_properties: { alter_table_properties_1 | { shrink_clause | RENAME TO new_table_name | READ ONLY | READ WRITE | REKEY encryption_spec | DEFAULT CO...
【 使用版本 】 3.2.x 【问题描述】执行语句报错,ALTER TABLE bank_flow_extract MODIFY COLUMN trade_amount DECIMAL(18, 2) NULL; 报错信息: [Not supported feature or function] 【复现路径】问题出现前后相关操作 【附件及日志】推荐使用OceanBase敏捷诊断工具obdiag收集诊断信息,详情参见链接(右键跳转查看): ...
alter system set data_copy_concurrency = 200; Incremental synchronization The following table describes the parameters for incremental synchronization, which are displayed only if you have selected Incremental Synchronization on the Select Migration Type page....
For a non-Oracle RAC database ALTER SYSTEM SET "_log_parallelism_max" = 1 SCOPE = spfile; When you modify the value of the _log_parallelism_max parameter in Oracle 10g, if the error message write to SPFILE requested but no SPFILE specified at startup is returned, perfor...
from or import data to OceanBase Database V3.2.4.0 and later, set the system parameteropen_cursorsto a larger value. Otherwise, an error may occur. After the data is imported or exported, reset the system parameter to the initial value, for example,ALTER SYSTEM SET open_cursors = 65535;....
Fix(dlm): job scheduler not found (#1690) [guowl3] Fix(structure-compare): alter table remove partitioning sql is not put in comment (#1674) [zhangxiao] Fix(notification): some event failed to be sent (#1629) [LuckyLeo] Fix(taskframework): use default entry point to replace init cmd...
SELECT TO_CHAR (SYSDATE, 'DD/MON/YYYY', 'nls_date_language=''Traditional Chinese'' ') FROM DUAL; An error is returned in the query result, because the value of the language parameter is not supported. ORA-12702: invalid NLS parameter string used in SQL function...
alter table hjjtesttable modify testyxj7 bigint COMMENT 'test'; ERROR 1235 (0A000): Alter non string type not supported 场景五:创建索引。 OceanBase 创建索引,增量同步正常;MySQL 创建索引,增量同步正常。 场景六:删除索引。 MySQL创建索引,增量同步正常;OceanBase 创建索引,增量同步正常。