April 13, 2006 at 9:07 am
I am setting up transactional replication of 7 tables between a SQL Server 2000 database and an Oracle database. I am using a DTS package to Transform the data, so it will use bind variables. My question is in regrads to the requirements for the subscriber login. Currently the replication is setup using the owner of the oracle tables, but I have been tasked with changing the user connection for the subscriber from the table owner to a user that has been granted select and update permissions to the tables on the oracle side. When I try to change the subscriber to use the other login the distribution agent fails with 'Table does not exist'. I tried creating a public synonym for the oracle table and granting permissions for the user to the synonym, but it still fails with 'Table does not exist'. Does the subscriber have to be the owner of the tables?
April 17, 2006 at 8:00 am
This was removed by the editor as SPAM
April 20, 2006 at 11:02 am
We use owner of tables in our replication from SQL to Oracle. In our case, we have 7 corresponding staging tables on Oracle for plain data load. Then some procedures on Oracle side to validate and insert/update in the real target tables.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply