-
Errors In Replication-ORA-00439: feature not enabled: Advanced replication
hi,
I am doing the multi master replication. i git erreos executing the below staemet
BEGIN
DBMS_REPCAT.ADD_MASTER_DATABASE(
gname => '"G10"',
master => 'ORCL.US.ORACLE.COM',
use_existing_objects => TRUE,
copy_rows => TRUE,
propagation_mode => 'SYNCHRONOUS');
END;
/
Error:
BEGIN
*
ERROR at line 1:
ORA-00439: feature not enabled: Advanced replication
ORA-06512: at "SYS.DBMS_SNAP_INTERNAL", line 302
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 2115
ORA-06512: at "SYS.DBMS_REPCAT", line 146
ORA-06512: at line 2
Can any body help in this??/
Venkata vara Prasad Kosaraju
-
Re: Errors In Replication-ORA-00439: feature not enabled: Advanced replication
It is because you need Oracle Enterprise Edition for AR.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Did you install Advance Replication during oracle installation?
to check
SQL>select * from v$option where parameter = 'Advanced replication';
PARAMETER VALUE
------------------------------ ------------------------------
Advanced replication TRUE
_________________________________
Why on earth OCP is to be proud
-
It is showing
SQL>select * from v$option where parameter = 'Advanced replication';
PARAMETER VALUE
------------------------------ ------------------------------
Advanced replication FALSE
What are pre reqistts fro Replication
Venkata vara Prasad Kosaraju
-
Originally posted by prasadkvv
It is showing
SQL>select * from v$option where parameter = 'Advanced replication';
PARAMETER VALUE
------------------------------ ------------------------------
Advanced replication FALSE
What are pre reqistts fro Replication
EE
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|