Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 4FE899FBBE4 for ; Thu, 15 Mar 2007 17:21:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 43534-02 for ; Thu, 15 Mar 2007 17:20:54 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from vms046pub.verizon.net (vms046pub.verizon.net [206.46.252.46]) by postgresql.org (Postfix) with ESMTP id 2F6CF9FB859 for ; Thu, 15 Mar 2007 17:20:57 -0300 (ADT) Received: from new-host.home ([71.166.59.121]) by vms046.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0JEY00BTFOIFY6H1@vms046.mailsrvcs.net> for pgsql-general@postgresql.org; Thu, 15 Mar 2007 15:20:42 -0500 (CDT) Date: Thu, 15 Mar 2007 16:20:34 -0400 From: Robert Treat Subject: Re: [SQL] PostgreSQL to Oracle In-reply-to: <36e682920703091032u22cd9901w6212c9aba999ec8c@mail.gmail.com> To: pgsql-general@postgresql.org Cc: "Jonah H. Harris" , "Ezequias Rodrigues da Rocha" Message-id: <200703151620.34309.xzilla@users.sourceforge.net> MIME-version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7bit Content-disposition: inline References: <55c095e90703090954m74e2b06arf73e3037f25f5c18@mail.gmail.com> <36e682920703091032u22cd9901w6212c9aba999ec8c@mail.gmail.com> User-Agent: KMail/1.9.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/933 X-Sequence-Number: 111122 On Friday 09 March 2007 13:32, Jonah H. Harris wrote: > To copy the data and table definitions, I'd use a database link (on > the Oracle side) with hsodbc connecting to your PostgreSQL system via > ODBC. > Do you find this works well? I've used it from some older Oracle instances connecting back into PostgreSQL and the results I had have been flakey at best. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL