ORACLE 迁移 openGauss 6.0 A 模式 改造清单

ALTER SESSION SET 会话参数none · minor · ora.syntax.alter_session ANYDATA 动态类型列undeclared · critical · ora.type.anydata ASCIISTR Unicode 转义函数undeclared · major · ora.func.asciistr 关联数组（INDEX BY 表）partial · major · ora.plsql.associative_array AT TIME ZONE 时区表达式partial · major · ora.func.at_time_zone AUTHID 执行者/定义者权限模式undeclared · critical · ora.plsql.authid 自治事务（PRAGMA AUTONOMOUS_TRANSACTION）none · blocker · ora.plsql.autonomous_txn 触发器内自治事务undeclared · blocker · ora.trigger.autonomous_transaction 视图 BEQUEATH 子句none · minor · ora.ddl.bequeath BFILE 外部文件类型none · critical · ora.type.bfile BFILENAME 外部文件定位函数undeclared · critical · ora.func.bfilename BIN_TO_NUM 位序列转数值undeclared · major · ora.func.bin_to_num BINARY_DOUBLE 类型partial · minor · ora.type.binary_double BINARY_FLOAT 类型none · minor · ora.type.binary_float Oracle 二进制浮点特殊字面量undeclared · critical · ora.literal.binary_float_special 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 CHAR 定长补空格类型partial · minor · ora.type.char_padding CHR(0) NUL 字符语义差异undeclared · major · ora.func.chr_zero Oracle 聚簇表与 CLUSTER 子句none · major · ora.object.cluster_table Oracle 集合 CARDINALITYundeclared · major · ora.func.cardinality SQL 层集合运算函数partial · major · ora.func.collection_sql 列 DEFAULT 使用序列伪列none · major · ora.column.default_sequence 复合 UNIQUE 的部分 NULL 唯一性语义undeclared · blocker · ora.constraint.composite_unique_null CONNECT BY 操作数含函数undeclared · critical · ora.syntax.connect_by_function_operand 约束 DISABLE 状态partial · major · ora.ddl.constraint_disable CREATE INDEX ... NOLOGGINGundeclared · major · ora.ddl.create_index_nologging DBLINK 引用（obj@link）partial · major · ora.object.dblink_ref 过程体内 DBLINK 引用（obj@link）partial · critical · ora.plsql.dblink_in_body DBMS_RANDOM 随机数调用（过程体内）partial · minor · ora.pkg.dbms_random DBMS_RANDOM 包调用partial · minor · ora.func.dbms_random DBMS_JOB 定时作业调用（过程体内）partial · major · ora.pkg.dbms_job DBMS_SCHEDULER 调度器调用（过程体内）partial · major · ora.pkg.dbms_scheduler DBMS_SCHEDULER / DBMS_JOB 调度作业partial · major · ora.plsql.dbms_scheduler DBTIMEZONE 数据库时区函数undeclared · major · ora.func.dbtimezone DEFAULT ON NULL 列默认值none · minor · ora.column.default_on_null DETERMINISTIC 函数标记partial · minor · ora.plsql.deterministic DROP USER ... CASCADE 级联删除undeclared · critical · ora.ddl.drop_user_cascade DUMP 内部表示诊断函数partial · major · ora.func.dump 动态 SQL（EXECUTE IMMEDIATE）partial · major · ora.plsql.dynamic_sql OPEN FOR 直接使用 SQL 字符串表达式partial · critical · ora.cursor.open_expression 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 FIRST_VALUE IGNORE NULLSnone · major · ora.func.first_value_ignore_nulls FLASHBACK 查询（AS OF SCN/TIMESTAMP、VERSIONS BETWEEN）none · major · ora.syntax.flashback_query SELECT ... FOR UPDATE OF 列级锁定写法partial · minor · ora.syntax.for_update_of 外连接查询 FOR UPDATEundeclared · critical · ora.syntax.for_update_outer_join FORALL 批量 DMLpartial · major · ora.plsql.forall CREATE FORCE VIEWnone · minor · ora.ddl.view_force FROM_TZ 时区附加函数undeclared · major · ora.func.from_tz Oracle Text 全文索引与 CTX 包none · critical · ora.index.fulltext_context PL/SQL 代码中的全角标点none · major · ora.plsql.fullwidth_punctuation 索引表达式中的 TO_DATE/TO_CHARundeclared · critical · ora.index.nonimmutable_conversion 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 DBMS_NETWORK_ACL_ADMIN 方法级黑名单undeclared · major · ora.pkg.harvest_dbms_network_acl_admin_methods DBMS_NETWORK_ACL_UTILITY 方法级黑名单undeclared · major · ora.pkg.harvest_dbms_network_acl_utility_methods DBMS_REPORT 方法级黑名单undeclared · major · ora.pkg.harvest_dbms_report_methods DBMS_REPUTIL 方法级黑名单undeclared · critical · ora.pkg.harvest_dbms_reputil_methods DBMS_SPM 方法级黑名单undeclared · major · ora.pkg.harvest_dbms_spm_methods DBMS_WORKLOAD_CAPTURE 方法级黑名单undeclared · major · ora.pkg.harvest_dbms_workload_capture_methods DBMS_WORKLOAD_REPLAY 方法级黑名单undeclared · major · ora.pkg.harvest_dbms_workload_replay_methods DBMS_XMLQUERY 方法级黑名单undeclared · major · ora.pkg.harvest_dbms_xmlquery_methods DBMS_XMLSAVE 方法级黑名单undeclared · critical · ora.pkg.harvest_dbms_xmlsave_methods DBMS_XSLPROCESSOR 方法级黑名单undeclared · major · ora.pkg.harvest_dbms_xslprocessor_methods CTX_DDL 方法级黑名单undeclared · major · ora.pkg.harvest_ctx_ddl_methods DBMS_APPLICATION_INFO 方法级黑名单undeclared · major · ora.pkg.harvest_dbms_application_info_methods DBMS_AQ 方法级黑名单undeclared · critical · ora.pkg.harvest_dbms_aq_methods DBMS_ASSERT 方法级黑名单undeclared · major · ora.pkg.harvest_dbms_assert_methods DBMS_CRYPTO 方法级黑名单undeclared · critical · ora.pkg.harvest_dbms_crypto_methods DBMS_JAVA 方法级黑名单undeclared · critical · ora.pkg.harvest_dbms_java_methods DBMS_LDAP 方法级黑名单undeclared · major · ora.pkg.harvest_dbms_ldap_methods DBMS_LOB 方法级黑名单undeclared · major · ora.pkg.harvest_dbms_lob_methods