Prev: Replication error
Next: SQL Server 2005 Replication Question
From: MattDeWitt on 28 Apr 2010 12:02
I have successfully created an Oracle publisher in SQL 2008. woohoo!

It's kind of a groovy thing, being able to set an oracle db to be a
publisher.

The bad part...one of the bad parts, is that I cannot find the objects I
want to publish. In my oracle instance, I have a schema named ZAPHOD (not
really but ...) and it has a user named ZAPHOD. The user is the owner and
can do anything it wants to the objects. This user also has permission to
see other schema / objects in the database. BUT, when I try to create the
publications I cannot see the ZAPHOD schema objects. I can however, see
objects from the other schemas.

Why can't I see the objects for the user/schema I am using to connect to
the db? (and yes I made sure that the objects are tables, have primary keys
and all the other stuff BOL tells me to check)
--
Matt D
Sr DBA / Architect
 | 
Pages: 1
Prev: Replication error
Next: SQL Server 2005 Replication Question