ORA-23364: Feature not enabled: Advanced replication

文档解释

ORA-23364: Feature not enabled: Advanced replication

Cause: The Advanced Replication feature is not enabled at this site. Updatable materialized views, deferred RPCs, and other replication features are, therefore, unavailable.

Action: Do not attempt to use this feature. Contact an Oracle Customer Support representative if the Advanced Replication feature has been purchased but not enabled.

ORA-23364：表示高级复制功能没有被启用。

官方解释

常见案例

一般处理方法及步骤

1.在系统中检查是否已启用高级复制功能

若没有启用，使用如下步骤来启用：

步骤一：打开一个SQL*Plus，建立新的复制管理：

Create Replication Management Type = Advanced;

步骤二：启用所有高级复制的服务

Exec DBMS_REPCAT.GRANT_SYSTEM_PRIVILEGE (‘REPLICATION_ADMINISTER’);

步骤三：刷新所有相关的组件

Exec DBMS_REFRESH.REFRESH(‘ALL’);