or use a Java stored procedure on Oracle, accessing pgsql via JDBC.
Brad.Odland_at_qtiworld.com wrote:
> xml?
>
>
>
> -----Original Message-----
> Sent: Wednesday, October 22, 2003 12:04 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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: David Hau
INET: davehau123_at_netscape.net
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:34:42 CDT
