Replicating ORACLE views?

I have successfully replicated ORACLE tables to a SQL Server, however
I don't see ORACLE views listed in the "Articles" dialog when I open
the ORACLE publication properties.
Is this because it is not possible to replicate ORACLE views or am i
missing something?
TIA
This is not supported for Oracle publishers - pls take a look at
sp_addarticle (http://msdn2.microsoft.com/en-us/library/ms173857.aspx)
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||Hi,
I am trying to setup transactional replication between an Oracle DB (one
table - that too few of the columns) and SQL Server 2005. Can you please
point me to an article or web page where I can get some instructions. I have
followed the step in BOL and getting nowhere. Your help will be much
appreciated.
Thank you,
Yoga
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uw28PlTUHHA.1016@.TK2MSFTNGP04.phx.gbl...
> This is not supported for Oracle publishers - pls take a look at
> sp_addarticle (http://msdn2.microsoft.com/en-us/library/ms173857.aspx)
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
|||I know Andrew Carter was looking for people using the functionality to work
with a while back
(http://blogs.msdn.com/ascarter/archive/2004/08/05/209056.aspx) - might be
worth contacting him. There's also a webcast:
http://whitepapers.techrepublic.com.com/whitepaper.aspx?docid=149653. Apart
from that I think Sujoy Paul's Replication book has a section on setting it
up as far as I recall.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com