Path: news.f.de.plusline.net!news-fra1.dfn.de!newsfeed.hanau.net!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!news.glorb.com!news.astraweb.com!router2.astraweb.com!216.168.1.164.MISMATCH!sn-xt-sjc-04!sn-xt-sjc-01!sn-post-sjc-01!supernews.com!corp.supernews.com!not-for-mail From: "klabu" Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server Subject: Re: Some Data from SServer to Oracle - Options ? Date: Sat, 11 Nov 2006 02:00:38 -0500 Organization: Posted via Supernews, http://www.supernews.com Message-ID: <12lat8njpctfvf6@corp.supernews.com> References: <12l9dcsplo28vd5@corp.supernews.com> <1163202059.177961@bubbleator.drizzle.com> X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-RFC2646: Format=Flowed; Response X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Complaints-To: abuse@supernews.com Lines: 16 Xref: news.f.de.plusline.net comp.databases.oracle.misc:76676 comp.databases.oracle.server:189311 "DA Morgan" > How much data? Both companies offer solutions for this. From my > experience the Oracle one is more likely to work with newer versions > of Oracle. Just a SELECT.....like < 1000 records I read this http://www.oracle.com/technology/products/oracle9i/datasheets/gateways/gateway_rel2_ds.html Transparent Gateway is not an option (10gR2/Linux) Generic Connectivity - not sure if I read it correctly - restriction : Installed on the same machine as the database