ORACLE 迁移 panweidb 3.0 A 模式 改造清单

ALTER SESSION SET 会话参数none · minor · ora.syntax.alter_session 关联数组(INDEX BY 表)partial · major · ora.plsql.associative_array AT TIME ZONE 时区表达式partial · major · ora.func.at_time_zone 自治事务(PRAGMA AUTONOMOUS_TRANSACTION)none · blocker · ora.plsql.autonomous_txn 视图 BEQUEATH 子句none · minor · ora.ddl.bequeath BFILE 外部文件类型none · critical · ora.type.bfile BINARY_FLOAT / BINARY_DOUBLE 类型partial · minor · ora.type.binary_float BITMAP 位图索引none · major · ora.index.bitmap BULK COLLECT 批量取数partial · major · ora.plsql.bulk_collect LENGTHB / SUBSTRB / INSTRB 字节语义函数partial · major · ora.func.byte_semantics CDB/多租户与排序规则 DDL 子句(SHARING / DEFAULT COLLATION / CONTAINER_MAP)none · minor · ora.ddl.container_clauses Oracle 聚簇表与 CLUSTER 子句none · major · ora.object.cluster_table SQL 层集合运算函数partial · major · ora.func.collection_sql 列 DEFAULT 使用序列伪列none · major · ora.column.default_sequence 约束 DISABLE 状态partial · major · ora.ddl.constraint_disable 过程体内 DBLINK 引用(obj@link)partial · critical · ora.plsql.dblink_in_body, ora.object.dblink_ref DBMS_RANDOM 随机数调用(过程体内)none · minor · ora.pkg.dbms_random, ora.func.dbms_random DBMS_JOB 定时作业调用(过程体内)partial · major · ora.pkg.dbms_job, ora.pkg.dbms_scheduler, ora.plsql.dbms_scheduler DEFAULT ON NULL 列默认值none · minor · ora.column.default_on_null DETERMINISTIC 函数标记partial · minor · ora.plsql.deterministic 动态 SQL(EXECUTE IMMEDIATE / DBMS_SQL)partial · major · ora.plsql.dynamic_sql EDITIONABLE / NONEDITIONABLE 关键字none · minor · ora.ddl.editionable EMPTY_CLOB / EMPTY_BLOB 函数none · minor · ora.func.empty_lob EXCEPTION 异常处理块partial · minor · ora.plsql.exception_block Java/C 外部语言存储例程none · critical · ora.plsql.external_routine 外部表(ORGANIZATION EXTERNAL)none · critical · ora.object.external_table FLASHBACK 查询(AS OF SCN/TIMESTAMP、VERSIONS BETWEEN)none · major · ora.syntax.flashback_query SELECT ... FOR UPDATE OF 列级锁定写法partial · minor · ora.syntax.for_update_of FORALL 批量 DMLpartial · major · ora.plsql.forall CREATE FORCE VIEWpartial · minor · ora.ddl.view_force Oracle Text 全文索引与 CTX 包none · critical · ora.index.fulltext_context PL/SQL 代码中的全角标点none · major · ora.plsql.fullwidth_punctuation MDSYS / SDO 空间类型与包none · critical · ora.func.gis_sdo GOTO 语句partial · minor · ora.plsql.goto GREATEST / LEAST 函数(NULL 传播差异)partial · major · ora.func.greatest_least GROUP_ID / GROUPING_ID 分组函数partial · minor · ora.func.grouping_id 对象/列标识符长度超过目标限制partial · minor · ora.limit.identifier_length IDENTITY 自增列partial · minor · ora.column.identity 单表索引数超过目标限制partial · minor · ora.limit.index_count INSERT ALL / INSERT FIRST 多表插入none · major · ora.syntax.insert_all NUMTOYMINTERVAL / NUMTODSINTERVAL / TO_YMINTERVAL / TO_DSINTERVALpartial · minor · ora.func.interval_conversion INTERVAL 自动分区partial · major · ora.partition.interval INTERVAL YEAR TO MONTH / DAY TO SECOND 类型partial · minor · ora.type.interval_columns 不可见列(INVISIBLE COLUMN)partial · minor · ora.column.invisible 索引组织表(ORGANIZATION INDEX)none · major · ora.object.iot KEEP (DENSE_RANK FIRST/LAST) 聚合子句none · major · ora.func.keep_dense_rank LISTAGG 聚合函数partial · minor · ora.func.listagg LNNVL 函数none · minor · ora.func.lnnvl LONG / LONG RAW 列类型none · major · ora.type.long LPAD / RPAD 函数(NULL 与多字节行为)partial · minor · ora.func.pad 物化视图(MATERIALIZED VIEW)none · major · ora.object.mview MERGE INTO 目标为内联视图none · major · ora.ddl.merge_into_view MERGE 的 UPDATE ... DELETE WHERE 组合子句none · major · ora.syntax.merge_update_delete SELECT MODEL 子句none · critical · ora.syntax.model_clause MONTHS_BETWEEN 函数partial · minor · ora.func.months_between MyBatis ${} 拼接对象名(表名/FROM/JOIN 位)none · critical · ora.app.mybatis_dollar_object, ora.app.mybatis_dollar_orderby NCHAR / NVARCHAR2 国家字符集类型partial · minor · ora.type.national_char NCLOB 国家字符大对象列none · major · ora.type.nclob 嵌套表集合类型(TABLE OF)partial · major · ora.plsql.nested_table NEXT_DAY 函数partial · minor · ora.func.next_day 单参数 TO_DATE/TO_TIMESTAMP(依赖会话 NLS 格式)partial · major · ora.behavior.nls_dependent_conversion NLSSORT 函数(语言排序规则)none · major · ora.func.nlssort DATABASE/SCHEMA 级触发器none · major · ora.trigger.non_table NVL2 函数兼容性none · major · ora.func.nvl2 对象表 CREATE TABLE OF 类型none · major · ora.object.object_table 对象类型(CREATE TYPE ... AS OBJECT / MEMBER 方法)none · critical · ora.plsql.object_type Optimizer Hint(/*+ ... */)partial · minor · ora.hint.optimizer_hint Oracle SQL/JSON 函数族(JSON_VALUE / JSON_TABLE 等)none · major · ora.func.json_functions PL/SQL 包(包级变量 / 初始化块)partial · critical · ora.plsql.package 分区数超过目标限制partial · minor · ora.limit.partition_count SYSTEM / REFERENCE 分区方法none · major · ora.partition.system_reference UPDATE 未带 WHEREnone · major · ora.perf.select_star, ora.perf.update_without_where, ora.perf.delete_without_where, ora.perf.cartesian_join, ora.perf.function_wrapped_column, ora.perf.implicit_date_string_compare, ora.perf.implicit_number_string_compare, ora.perf.not_in_subquery, ora.perf.or_chain, ora.perf.deep_nested_subquery, ora.perf.leading_wildcard_like, ora.perf.rownum_without_order, ora.perf.distinct_with_order, ora.perf.nvl_on_predicate_column, ora.perf.scalar_subquery_select, ora.perf.having_without_group_selectivity PIPELINED 管道表函数none · critical · ora.plsql.pipelined PIVOT / UNPIVOT 子句none · major · ora.syntax.pivot DBMS_ALERT 事务性告警通知调用none · critical · ora.pkg.dbms_alert DBMS_APPLICATION_INFO 会话标识调用partial · minor · ora.pkg.dbms_application_info DBMS_AQ / DBMS_AQADM 高级队列调用none · blocker · ora.pkg.dbms_aq DBMS_ASSERT 动态 SQL 校验包none · major · ora.pkg.dbms_assert DBMS_CRYPTO 加解密调用none · critical · ora.pkg.dbms_crypto DBMS_ERRLOG 与 LOG ERRORS 批量容错 DMLnone · major · ora.pkg.dbms_errlog