RE: Linking ORACLE 8i and ORACLE rdb7

From: Disser, Arno <a.disser_at_sfs.nl>
Date: Thu, 01 Feb 2001 16:20:08 -0800
Message-ID: <F001.002A8639.20010201162050@fatcity.com>

Hi,

We are currently having a working construction using RdB 7.0.5
Oracle 7.3.4.3.0,
Sqlnet4Rdb 1.0.2.5.0

and having no major problems, other than a poor performance in joins over this db-link and some problems with the differences in the usages of timestamps in both DBMS's.

However, my experiences tell that best performance for migration should be a "RMU/unload /record_format=(file=?.rrd, format=text) root table file.txt" to extract the data from Rdb and to load it using sqlloader and some nice controlfiles.

Wtith best regards,

                            /'^'\
Arno                       ( o o )
-----------------------oOOO--(_)--OOOo----------

Arno Disser
SFS/Pensioenen en Verzekeringen
FAD/ICT/DBA
Postbus 11
2280 AA RIJSWIJK The Netherlands

Tel     +31 (0)70 33 66 389
Fax     +31 (0)70 31 93 884

email <mailto:a.disser_at_sfs.nl>

-----Oorspronkelijk bericht-----
Van: Stephen Miller [mailto:miller_stephen_at_usa.net] Verzonden: donderdag 1 februari 2001 22:38 Aan: Multiple recipients of list ORACLE-L Onderwerp: Linking ORACLE 8i and ORACLE rdb7

To the list:

We currently run ORACLE rdb7 on a Compaq ALPHA system. We are in the process of migrating the whole works to ORACLE 8i on IBM AIX.

Does anyone have any experience in accessing ORACLE rdb7 using SQLNET or linking ORACLE 8i to ORACLE rdb7? We want to be able to transfer data between
the two platforms during the migration period for testing purposes.

However, we have found very little information on how, or even whether, we can
successfully use SQLNET for this purpose. There is supposedly a SQL*NET for rdb V1 product, but I need to know if anybody out there has experience with using it (good or bad).

TIA

  Stephen Miller
  Systems Specialist
  Fleet Technology Services
  401-275-7678
  mailto:miller_stephen_at_usa.net

Get free email and a permanent address at http://www.amexmail.com/?A=1
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Stephen Miller
INET: miller_stephen_at_usa.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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.com
--

Author: Disser, Arno
INET: a.disser_at_sfs.nl

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------