I'm in need of creating a read-only snapshot of Oracle data on my SQL Server 2000 machine. I have successfully registered the Oracle server as a "Linked" server, but when I try to make Oracle a publisher, that server doesn't show up in my available servers list - only SQL Server Servers show up.

My question is, can someone give me a detailed explanation of how to set up my SQL Server to do a snapshot replication of tables from my "linked" Oracle Server, and can I set it up to run daily? I would prefer not to use DTS.

Many thanks!
Washington, DC