| Oracle 9i Multi-master Replication [message #277498] |
Tue, 30 October 2007 06:37  |
M.Shakeel Azeem
Messages: 226
Registered: September 2006
|
Senior Member |
|
|
Oracle Version: 9.2.0.7.0
Operating System: windows server 2003
Dear All,
Did anybody ever implement Advanced Multi-master Replication in oracle 9i ?
For Example
i have two sites site1 and site2
Both sites have two tables tab1 and tab2 with the same specs.
i want to replicate both tables at both sides
If i update tab1 at site1 ,it'll update tab1 at site2 and vice versa.
If i update tab2 at site1 ,it'll update tab2 at site2 and vice versa.
Regards,
M.Shakeel Azeem
|
|
|
|
|
|
|
|
|
|
| Re: Oracle 9i Multi-master Replication [message #277775 is a reply to message #277498] |
Wed, 31 October 2007 08:22  |
M.Shakeel Azeem
Messages: 226
Registered: September 2006
|
Senior Member |
|
|
Dear All
i had successfully implement Mutlimaster Replication by using the link
http://www.oracle-base.com/articles/8i/AdvancedReplication.php
i had just added EMP table in Replication Environment and it was working fine .
i had basically done it with two sites
Now i want to add DEPT Table as well but unable to do so
What i had done to do it
1-CONNECT repadmin/repadmin@ABC
2-EXECUTE Dbms_Repcat.Suspend_Master_Activity(gname=>'MYREPGRP');
3-BEGIN
SQL> DBMS_REPCAT.CREATE_MASTER_REPOBJECT(
gname => '"MYREPGRP"',
type => 'TABLE',
oname => '"DEPT"',
sname => '"SCOTT"',
copy_rows => TRUE,
use_existing_object => TRUE);
END;
/
PL/SQL procedure successfully completed.
SQL>BEGIN
DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT(
sname => '"SCOTT"',
oname => '"DEPT"',
type => 'TABLE',
min_communication => TRUE,
generate_80_compatible => FALSE);
END;
/
PL/SQL procedure successfully completed.
But when i check the status from Enterprise Manager Console "View Administrative Requests"
For first procedure CREATE_MASTER_REPOBJECT
its giving the error
ORA-02292: integrity constraint (SCOTT.FK_DEPTNO) violated - child record found
ORA-02266: unique/primary keys in table referenced by enabled foreign keys
for second procedure GENERATE_REPLICATION_SUPPORT
ORA-23308: object SCOTT.DEPT does not exist or is invalid
DEPTNO is primary key in DEPT Table while its reffered as foriegn Key FK_DEPTNO in EMP table
Both tables DEPT and EMP Contain the same specs and same Data at both sites
I don't think there is any Foreign Key Voilation
what could be the Reasons ?
Can u please help me in this regard?
Regards,
M.Shakeel Azeem
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
