I think you are looking for the gateway, the way it works is it will setup a database link between SQL Server and Oracle, then Oracle will treat that SQL Server as another Oracle Server. Although I am not sure if you could use snapshots. May be you should contact Oracle about gateway´s functinality.