or a perl script - can connect to both postgresql and oracle in the same
script.
> -----Original Message-----
> From: Mladen Gogala [SMTP:mladen_at_wangtrading.com]
> 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: mladen_at_wangtrading.com
>
> 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: ListGuru_at_fatcity.com (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: sollig_at_lifetouch.com
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: ListGuru_at_fatcity.com (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).
Received on Wed Oct 22 2003 - 12:14:25 CDT
