ORA-23364: Feature not enabled: Advanced replication ORACLE 报错 故障修复 远程处理
文档解释
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’);