| Error during addtion of mastersite [message #354408] |
Sat, 18 October 2008 09:30  |
sanei05
Messages: 104
Registered: September 2008
|
Senior Member |
|
|
hi,
i get below error when i tried to add the master site to the master definition site.
SQL> BEGIN
2 DBMS_REPCAT.ADD_MASTER_DATABASE(
3 gname => 'TEST',
4 master=> 'testdb2',
5 use_existing_objects => FALSE,
6 copy_rows => FALSE,
7 propagation_mode => 'synchronous');
8 END;
9 /
BEGIN
*
ERROR at line 1:
ORA-00001: unique constraint (SYSTEM.REPCAT$_REPCAT_PRIMARY) violat
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 2632
ORA-06512: at "SYS.DBMS_REPCAT_RPC", line 306
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 2327
ORA-06512: at "SYS.DBMS_REPCAT", line 146
ORA-06512: at line 2
Can anyone help me where am i going wrong
|
|
|
|
|
|
|
|
|
|
| Re: Error during addtion of mastersite [message #356055 is a reply to message #355749] |
Wed, 29 October 2008 04:11  |
sanei05
Messages: 104
Registered: September 2008
|
Senior Member |
|
|
|
I was running this script on both database. Then I ran this script only in the master def site and gave the propagation mode as "ASYNCHRONOUS". Also I rectified the primary constraint from one of the table i had on both database. i guess you have to check with your tables on both databases.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
