I just saw this article.May its of some use.

http://www.microsoft.com/sql/techinfo/tips/administration/addingoracle.asp





--- "Welsh, Stephen" <[Email Address Removed] You have to set up an ODBC (System DSN) connection
> first on the SQL Server
> to the Oracle Server. Then you create a linked
> Server that will use that
> ODBC connection. Then you can create your publisher
> that allows SQL Server
> 2000 or Heterogeneous Data Sources, and then create
> a push subscription on
> the SQL Server to the Oracle server.
>
> -Stephen
>
> -----Original Message-----
> From: Thiagarajan Gopalakrishnan
> [mailto:Thiagarajan.[Email Address Removed] Sent: Tuesday, November 26, 2002 12:19 AM
> To: LazyDBA.com Discussion
> Subject: Oracle Subscription to a SQL Server
> Publication
>
>
> > Hi
> >
> > Could anyone help me to replicate between SQL
> Server and Oracle.
> >
> > The scenario is the Publishser is SQL Server and
> the Subscriber
> Oracle.
> >
> > The earlier you replies the better.
> >
> > Thanks & Regards
> > PG Thiagarajan
> >
>
>
---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT
> JUST REPLY
> To unsubscribe, e-mail:
> mssqldba-[Email Address Removed] For additional commands, e-mail:
> mssqldba-[Email Address Removed]
>
---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT
> JUST REPLY
> To unsubscribe, e-mail:
> mssqldba-[Email Address Removed] For additional commands, e-mail:
> mssqldba-[Email Address Removed]


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
MS Sql Server LazyDBA home page