The Oracle (tm) Users' Co-Operative FAQ

I've got ORA-00439 while executed ADD_MASTER_DATABASE (API or Replication Manager). Why ?

Author's name: Vadim Grepan

Author's Email:, 

Date written: 04-Sep-2001

Oracle version(s): 8i (8.1.*)

After switching the master definition site, I got the following message (API or Replication Manager) when I run ADD_MASTER_DATABASE: 
ERROR at line 1: 
ORA-00439: feature not enabled: Advanced replication 
ORA-06512: at "SYS.DBMS_SNAP_INTERNAL", line 134 
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 1873 
ORA-06512: at "SYS.DBMS_REPCAT", line 121 
ORA-06512: at line 2

Back to index of questions

The ORA-00439 means that you have not installed replication so make sure that you have the Enterprise Edition version and not Standard Edition. You can look at v$option and/or the banner when you startup svrmgr or SQL*Plus: 

SQL> select VALUE from v$option where PARAMETER='Advanced replication';

You have to have Oracle EE with Advanced Replication Option to create updateable snapshots or multy-master replication.

Further reading: Oracle8i Feature and Option Availability

Back to top

Back to index of questions