Hi list
I am using Oracle 9.2.0.1.0 enterprise on windows.
I am going thru the examples provided in Replication
Management API Reference-Part No. A96568-01.
While creating MVIEW REPLICATION GROUP, getting the
following error (page # 5-7)
SQL CONNECT mviewadmin/[EMAIL PROTECTED]
Connected.
Hi list
I am using Oracle 9.2.0.1.0 enterprise on windows.
I am going thru the examples provided in Replication
Management API Reference-Part No. A96568-01.
While creating MVIEW REPLICATION GROUP, getting the
following error (page # 5-7)
SQL CONNECT mviewadmin/[EMAIL PROTECTED]
Connected.
Before you create the Materialized View Group, you must create the REPGROUP
at the Master site, which in you case is ORC1.world.
In the database ORC1, use the DBMS_REPCAT.CREATE_MASTER_REPGROUP and
DBMS_REPCAT.CREATE_MASTER_REPOBJECT before calling the procedure
DBMS_REPCAT.CREATE_MVIEW_REPGROUP.
Dear Arup,
Thanks for your response. But i have done the same
which is mentioned in page # 3-6(Replication API
Reference Manual). Please see below. What else could
be wrong? TIA
CONNECT repadmin/[EMAIL PROTECTED]
BEGIN
DBMS_REPCAT.CREATE_MASTER_REPGROUP (
gname = 'hr_repg');
END;
/
BEGIN
Sami,
Setting up replication is pretty straight forward as long as you follow all
the steps dilligently. Unfortunately if a step is missed, it's hard to
diagnose the problem until one is at the terminal looking at the actual
database. In this case there are several steps that my not have been