ORACLE 迁移 oceanbase 4.2.5 oracle 模式 改造清单

ADD_MONTHS 函数unknown · minor · ora.func.add_months ALTER SESSION SET 会话参数unknown · minor · ora.syntax.alter_session ANYDATA 动态类型列unknown · critical · ora.type.anydata ASCIISTR Unicode 转义函数unknown · major · ora.func.asciistr 关联数组(INDEX BY 表)unknown · major · ora.plsql.associative_array AT TIME ZONE 时区表达式unknown · major · ora.func.at_time_zone AUTHID 执行者/定义者权限模式unknown · critical · ora.plsql.authid 自治事务(PRAGMA AUTONOMOUS_TRANSACTION)unknown · critical · ora.plsql.autonomous_txn 触发器内自治事务unknown · blocker · ora.trigger.autonomous_transaction 视图 BEQUEATH 子句unknown · minor · ora.ddl.bequeath BFILE 外部文件类型unknown · critical · ora.type.bfile BFILENAME 外部文件定位函数unknown · critical · ora.func.bfilename BIN_TO_NUM 位序列转数值unknown · major · ora.func.bin_to_num BINARY_DOUBLE 类型unknown · minor · ora.type.binary_double BINARY_FLOAT 类型unknown · minor · ora.type.binary_float Oracle 二进制浮点特殊字面量unknown · critical · ora.literal.binary_float_special BITAND 函数unknown · minor · ora.func.bitand BITMAP 位图索引unknown · major · ora.index.bitmap BULK COLLECT 批量取数unknown · major · ora.plsql.bulk_collect LENGTHB / SUBSTRB / INSTRB 字节语义函数unknown · major · ora.func.byte_semantics CDB/多租户与排序规则 DDL 子句(SHARING / DEFAULT COLLATION / CONTAINER_MAP)unknown · minor · ora.ddl.container_clauses CHAR 定长补空格类型unknown · minor · ora.type.char_padding CHR(0) NUL 字符语义差异unknown · major · ora.func.chr_zero Oracle 聚簇表与 CLUSTER 子句unknown · major · ora.object.cluster_table Oracle 集合 CARDINALITYunknown · major · ora.func.cardinality SQL 层集合运算函数unknown · major · ora.func.collection_sql 列 DEFAULT 使用序列伪列unknown · major · ora.column.default_sequence 存储过程内 COMMIT/ROLLBACKunknown · major · ora.plsql.commit_in_proc 复合 UNIQUE 的部分 NULL 唯一性语义unknown · blocker · ora.constraint.composite_unique_null 字符串拼接 || 的 NULL 语义unknown · minor · ora.behavior.concat_null CONNECT BY 层次查询unknown · critical · ora.syntax.connect_by CONNECT BY 操作数含函数unknown · critical · ora.syntax.connect_by_function_operand LEVEL 层次伪列unknown · major · ora.syntax.level_pseudocolumn CONNECT_BY_ROOT 层次操作符unknown · major · ora.syntax.connect_by_root 约束 DISABLE 状态unknown · major · ora.ddl.constraint_disable 游标属性(%FOUND/%NOTFOUND/%ISOPEN/%ROWCOUNT)unknown · major · ora.plsql.cursor_attributes SQL%BULK_ROWCOUNT 逐项批量 DML 计数unknown · critical · ora.cursor.sql_bulk_rowcount 游标 FOR 循环unknown · minor · ora.plsql.cursor_for_loop 日期直接加减数字(天数运算)unknown · major · ora.behavior.date_arithmetic DATE 映射 TIMESTAMP 后日期差聚合类型变化unknown · critical · ora.dm.timestamp_delta_aggregate DATE 类型含时间部分的语义unknown · major · ora.type.date_semantics DBLINK 引用(obj@link)unknown · major · ora.object.dblink_ref 过程体内 DBLINK 引用(obj@link)unknown · critical · ora.plsql.dblink_in_body DBMS_RANDOM 随机数调用(过程体内)unknown · minor · ora.pkg.dbms_random DBMS_RANDOM 包调用unknown · minor · ora.func.dbms_random DBMS_JOB 定时作业调用(过程体内)unknown · major · ora.pkg.dbms_job DBMS_SCHEDULER 调度器调用(过程体内)unknown · major · ora.pkg.dbms_scheduler DBMS_SCHEDULER / DBMS_JOB 调度作业unknown · major · ora.plsql.dbms_scheduler DBTIMEZONE 数据库时区函数unknown · major · ora.func.dbtimezone DECODE 函数unknown · major · ora.func.decode DEFAULT ON NULL 列默认值unknown · minor · ora.column.default_on_null DETERMINISTIC 函数标记unknown · minor · ora.plsql.deterministic DUAL 虚表unknown · minor · ora.syntax.dual DUMP 内部表示诊断函数unknown · major · ora.func.dump 动态 SQL(EXECUTE IMMEDIATE / DBMS_SQL)unknown · major · ora.plsql.dynamic_sql OPEN FOR 直接使用 SQL 字符串表达式unknown · critical · ora.cursor.open_expression EDITIONABLE / NONEDITIONABLE 关键字unknown · minor · ora.ddl.editionable EMPTY_CLOB / EMPTY_BLOB 函数unknown · minor · ora.func.empty_lob 与空串字面量的等值/不等比较('' 即 NULL 语义)unknown · critical · ora.behavior.empty_string_compare EXCEPTION 异常处理块unknown · minor · ora.plsql.exception_block 显式游标声明(CURSOR ... IS)unknown · minor · ora.plsql.cursor_explicit Java/C 外部语言存储例程unknown · critical · ora.plsql.external_routine 外部表(ORGANIZATION EXTERNAL)unknown · critical · ora.object.external_table FIRST_VALUE IGNORE NULLSunknown · major · ora.func.first_value_ignore_nulls FLASHBACK 查询(AS OF SCN/TIMESTAMP、VERSIONS BETWEEN)unknown · major · ora.syntax.flashback_query SELECT ... FOR UPDATE OF 列级锁定写法unknown · minor · ora.syntax.for_update_of 外连接查询 FOR UPDATEunknown · critical · ora.syntax.for_update_outer_join FOR UPDATE WAIT n 超时等待子句unknown · minor · ora.syntax.for_update_wait FORALL 批量 DMLunknown · major · ora.plsql.forall CREATE FORCE VIEWunknown · minor · ora.ddl.view_force FROM_TZ 时区附加函数unknown · major · ora.func.from_tz Oracle Text 全文索引与 CTX 包unknown · critical · ora.index.fulltext_context PL/SQL 代码中的全角标点unknown · major · ora.plsql.fullwidth_punctuation 索引表达式中的 TO_DATE/TO_CHARunknown · critical · ora.index.nonimmutable_conversion MDSYS / SDO 空间类型与包unknown · critical · ora.func.gis_sdo 全局临时表(GLOBAL TEMPORARY TABLE)unknown · major · ora.object.gtt GOTO 语句unknown · major · ora.plsql.goto GREATEST / LEAST 函数(NULL 传播差异)unknown · major · ora.func.greatest_least GROUP_ID / GROUPING_ID 分组函数unknown · minor · ora.func.grouping_id 对象/列标识符长度超过目标限制unknown · minor · ora.limit.identifier_length

社群/联系

迁移卡住时,带着案例找人复核

迁移路上遇到具体问题?微信群、1v1 咨询与邮箱,随时找得到人。

微信交流群 微信二维码

扫码添加微信,邀您加入交流群;亦可搜索微信号 prejudice_me。

邮箱咨询

m01dm01db01@foxmail.com

发源库、目标库、代码规模和已脱敏案例短链,便于估算改造工作量。