I have tried to set up multimaster replication using oracle9i
on 2 db.
both dbs are running on the same m/c
For testing pupose i have followed oracle 9i Adv. replication guideline and used "HR" db to create replication.
login as sysdba on test1 DataBase
Click on Advanced Replication
1>create setup master sites
selected both dbs- test1, test2
Default users- REPADMIN
Defualt password - REPADMIN
selected default link scheduling,job scheduling
2>create setup master groups
login as repadmin on test1 db
NAME : MYRP
OBJECTS : select HR schema,
set "copy rows" = no(false)
MASTER SITES :
master definition site: test1.orcl.us.com
add - select "All databse links"
added test2.orcl.us.com from the list
ticked options - Asychnorous
use existing objects
Once its created i have seen the table name of HR schema changed to below form
HR.COUNTRY Became HR.BIN$3gpCdqnrSSCRscSpDX+DTA==$0
How can i get back original tables name,or what shall i do before adding schema objects to master group in replication avoid this problem.
[Updated on: Thu, 01 December 2005 22:23]
Report message to a moderator