Message-Id: <26007.339451@fatcity.com> From: "Adams, Matthew (GECP, MABG, 088130)" Date: Thu, 24 Jul 2003 11:19:26 -0400 Subject: RE: backwards export This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------=_NextPartTM-000-67cec0e4-80cf-41c0-8720-befd379042cf Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C351F6.F80B62AA" ------_=_NextPart_001_01C351F6.F80B62AA Content-Type: text/plain; charset="iso-8859-1" > I'm not sure of the export compatibility, but you should know that 9i > clients won't talk to a 7.3.4 database, True > and 7.3.4 clients won't talk to a > 9.2 database, False A Oracle7 client can, will, and does talk to a 9.2.0 database with no problem. > which could be a problem. At least, they're not certified > to talk to each other, which isn't quite the same thing. See note 172179.1 on Metalink. To quote: "In short, any version of SQL*Net's version 2 Client (2.3.x) and up to Net 9.0.x, will be able to connect to any version of Oracle Database version 7.3.x and up to 9.2.x, with certain compatibility issues that are explained below" Matt Adams ---- Matt Adams - GE Appliances - matt.adams@appl.ge.com It will make sense when you stop thinking logically, and start thinking Oracle-ly - Jim Droppa -----Original Message----- From: Simon.Anderson@scisys.co.uk [mailto:Simon.Anderson@scisys.co.uk] Sent: Wednesday, July 23, 2003 8:55 AM To: Multiple recipients of list ORACLE-L Subject: Re: backwards export I'm not sure of the export compatibility, but you should know that 9i clients won't talk to a 7.3.4 database, and 7.3.4 clients won't talk to a 9.2 database, which could be a problem. At least, they're not certified to talk to each other, which isn't quite the same thing. Cheers Simon Anderson Jeroen van Sluisdam Sent by: ml-errors@fatcity.com 23/07/2003 12:49 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L cc: Subject: backwards export Hi, We are investigating possibilities for migration of an oracle 7.3.4 to oracle 9i. We want to separate our production DB from the app-logic such that we can migrate from oracle 7.3.4 on hp-ux 10.20 to oracle 9i on hp-ux 11. Problem is our development and test-environment because we cannot separate the logic at the same time here also from the db (costs). Does anyone have any experience with exporting from oracle 9i to oracle 7.3.4 ? I found the underlying note on metalink about the same problem but with oracle 8. I have limited experience on oracle8 and none on oracle 9. So I hope you can give some tips. .......................... You need to run the 7.3 version of export against your 8.0 database via sqlnet/net8. Beforehand, you need to run rdbms/admin/catexp7.sql against your 8.0 database. This creates the 7.3 export views required. Note that if you have used any 8.0 specific features (e.g. objects) these will not be exported for obvious reasons. ........................ Tia, Jeroen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Simon.Anderson@scisys.co.uk 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@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). ------_=_NextPart_001_01C351F6.F80B62AA Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: backwards export

> I'm not sure of the export compatibility, but = you should know that 9i
> clients won't talk to a 7.3.4 database,

  True

> and 7.3.4 clients won't talk to a
> 9.2 database,
 
 False

  A Oracle7 client can, will, and does talk to a = 9.2.0 database
with no problem.

> which could be a problem.  At least, = they're not certified
> to talk to each other, which isn't quite the = same thing.

  See note 172179.1 on Metalink.  To = quote:

"In short, any version of SQL*Net's version 2 = Client (2.3.x) and
up to Net 9.0.x, will be able to connect to any = version of
Oracle Database version 7.3.x and up to 9.2.x, with = certain
compatibility issues that are explained = below"


Matt Adams
----
Matt Adams - GE Appliances - = matt.adams@appl.ge.com
It will make sense when you stop thinking = logically,
and start thinking Oracle-ly  -  Jim = Droppa

-----Original Message-----
From: Simon.Anderson@scisys.co.uk [mailto:Simon.Anderson@scisys= .co.uk]
Sent: Wednesday, July 23, 2003 8:55 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: backwards export


I'm not sure of the export compatibility, but you = should know that 9i
clients won't talk to a 7.3.4 database, and 7.3.4 = clients won't talk to a
9.2 database, which could be a problem.  At = least, they're not certified
to talk to each other, which isn't quite the same = thing.

Cheers
Simon Anderson






Jeroen van Sluisdam = <jeroen.van.sluisdam@vrijuit.nl>
Sent by: ml-errors@fatcity.com
23/07/2003 12:49
Please respond to ORACLE-L

 
        = To:     Multiple recipients of list ORACLE-L = <ORACLE-L@fatcity.com>
        cc: =
        = Subject:        backwards = export


Hi,
 
We are investigating possibilities for migration of = an oracle 7.3.4 to
oracle 9i. We want to separate our
production DB from the app-logic such that we can = migrate from oracle
7.3.4 on hp-ux 10.20 to oracle 9i
on hp-ux 11. Problem is our development and = test-environment because we
cannot separate the logic at the
same time here also from the db (costs). Does anyone = have any experience
with exporting from oracle 9i
to oracle 7.3.4 ?
 
I found the underlying note on metalink about the = same problem but with
oracle 8. I have limited experience on = oracle8
and none on oracle 9. So I hope you can give some = tips.
..........................
You need to run the 7.3 version of export against = your 8.0 database via
sqlnet/net8. Beforehand, you need to run = rdbms/admin/catexp7.sql against
your 8.0 database. This creates the 7.3 export views = required. Note that
if you have used any 8.0 specific features (e.g. = objects) these will not
be exported for obvious reasons.
........................
 
Tia,
 
Jeroen


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
  INET: Simon.Anderson@scisys.co.uk

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@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 =