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:[EMAIL PROTECTED]>
------------------------------------------------
-----Oorspronkelijk bericht-----
Van: Stephen Miller [mailto:[EMAIL PROTECTED]]
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:[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
____________________________________________________________________
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: [EMAIL PROTECTED]
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: [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.com
--
Author: Disser, Arno
INET: [EMAIL PROTECTED]
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: [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).
