ORA-16288: DDL skipped due to missing edition “string” ORACLE 报错 故障修复 远程处理

文档解释

ORA-16288: DDL skipped due to missing edition “string”

Cause: The edition in which the DDL was performed on the primary did not exist on the standby database.

Action: No action is necessary. This informational statement is provided to record the event for diagnostic purposes.

官方解释

ORA-16288: DDL skipped due to missing edition string

Cause: The processor encountered an edition-based redefinition operation which uses the edition string, but the edition specified by the edition string could not be found.

Action: Create the edition with the specified string in the dictionary or modify the edition string to refer to an existing edition.

常见案例

一般处理方法及步骤

1. 先设置当前版本修订：

SQL> ALTER SESSION SET edition = version

2. 重新编译edition view：

SQL> ALTER EDITION EDITION_NAME COMPILE EDITION VIEW view_name;

3. 重新执行DDL操作：

SQL> ALTER TABLE…