or a perl script - can connect to both postgresql and oracle in the same script.
> -----Original Message----- > From: Mladen Gogala [SMTP:[EMAIL PROTECTED] > Sent: Wednesday, October 22, 2003 12:04 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Share Data between PostgreSQL and Oracle > > Oracle external procedures, accessing PostgreSQL would do the trick > without flat files. > On 10/22/2003 12:14:24 PM, David Wagoner wrote: > > Anyone have experience doing this? I would like to hear your tips and > > experiences. > > Here's our situation. We have an Oracle DB on Sun Solaris 8 and a > > PostgreSQL > > DB on Linux (RH 7.3) that we need to share data between, specifically > > from > > PostgreSQL to Oracle. I want to experiment with Oracle's Generic > > Connectivity via ODBC connection. The advantage here seems to be > > DB-to-DB > > connection, ability to use Oracle SQL and tools, etc. Limitations > > might be > > network performance. > > An alternative is to produce flat files from PostgreSQL, FTP them to > > Oracle > > server, and SQL*Load them into Oracle. Not a real-time solution, but > > load > > performance is usually very good with SQL*Loader. > > > > Thoughts? > > > > > > Best regards, > > > > David B. Wagoner > > Database Administrator > > Arsenal Digital Solutions > > Web: http://www.arsenaldigital.com > > > > <<...OLE_Obj...>> > > > > > > The contents of this e-mail message may be privileged and/or > > confidential. > > If you are not the intended recipient, any review, dissemination, > > copying, > > distribution or other use of the contents of this message or any > > attachment > > by you is strictly prohibited. If you receive this communication in > > error, > > please notify us immediately by return e-mail or by telephone > > (919-466-6700), and please delete this message and all attachments > > from your > > system. > > Thank you. > > > > > > Mladen Gogala > Oracle DBA > > > > Note: > This message is for the named person's use only. It may contain > confidential, proprietary or legally privileged information. No > confidentiality or privilege is waived or lost by any mistransmission. If > you receive this message in error, please immediately delete it and all > copies of it from your system, destroy any hard copies of it and notify > the sender. You must not, directly or indirectly, use, disclose, > distribute, print, or copy any part of this message if you are not the > intended recipient. Wang Trading LLC and any of its subsidiaries each > reserve the right to monitor all e-mail communications through its > networks. > Any views expressed in this message are those of the individual sender, > except where the message states otherwise and the sender is authorized to > state them to be the views of any such entity. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: STEVE OLLIG INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).