February 3, 2005 at 2:40 pm
I'm creating a heterogeneous,transactional subscriber (Oracle 9iR1) with a SQL Server 2000 publisher.
1. What is the purpose of the MSREPL7 table that gets created on Oracle during replication when the SQL Server Distribution Agent starts up?
2. The second time the distribution agent is started, the job fails because the Distribution Agent tries to create this table in Oracle again and it already exists. How do I stop SQL Server from trying to recreate this table upon startup on the Distribution Agent?
Regards,
Timo
February 7, 2005 at 8:00 am
This was removed by the editor as SPAM
May 15, 2006 at 3:20 am
I'm getting the exact same problem, it is very frustrating!
Did you find a solution?
May 15, 2006 at 9:14 am
James, I did eventually resolve this problem but it was a year ago so I do not recall all the details. I vaguely remember, editing the script file that SQL Server creates for a publication each time a new one is created so that this table is not recreated. In fact, I took that entire script file from SQL Server, and built the Oracle target pub table on my own after ignroing the script to build the MSREPL7 table. Then, I just left a single line GO statement in the SQL script so that publication initialization takes effect without other changes.
February 20, 2008 at 9:22 pm
mark
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply