| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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
-----Original Message-----
From: Simon.Anderson_at_scisys.co.uk [mailto:Simon.Anderson_at_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_at_vrijuit.nl>
Sent by: ml-errors_at_fatcity.com
23/07/2003 12:49
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_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.
..........................
........................
Tia,
Jeroen
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Simon.Anderson_at_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_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). ------_=_NextPart_001_01C351F6.F80B62AA Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2655.35"> <TITLE>RE: backwards export</TITLE> </HEAD> <BODY> <BR> <BR> <P><FONT SIZE=3D2>> I'm not sure of the export compatibility, but = you should know that 9i </FONT> <BR><FONT SIZE=3D2>> clients won't talk to a 7.3.4 database, </FONT> </P> <P><FONT SIZE=3D2> True</FONT> </P> <P><FONT SIZE=3D2>> and 7.3.4 clients won't talk to a </FONT> <BR><FONT SIZE=3D2>> 9.2 database, </FONT> <BR><FONT SIZE=3D2> </FONT> <BR><FONT SIZE=3D2> False</FONT> </P> <P><FONT SIZE=3D2> A Oracle7 client can, will, and does talk to a = 9.2.0 database </FONT> <BR><FONT SIZE=3D2>with no problem.</FONT> </P> <P><FONT SIZE=3D2>> which could be a problem. At least, = they're not certified </FONT> <BR><FONT SIZE=3D2>> to talk to each other, which isn't quite the = same thing.</FONT> </P> <P><FONT SIZE=3D2> See note 172179.1 on Metalink. To = quote:</FONT> </P> <P><FONT SIZE=3D2>"In short, any version of SQL*Net's version 2 = Client (2.3.x) and </FONT> <BR><FONT SIZE=3D2>up to Net 9.0.x, will be able to connect to any = version of </FONT> <BR><FONT SIZE=3D2>Oracle Database version 7.3.x and up to 9.2.x, with = certain </FONT> <BR><FONT SIZE=3D2>compatibility issues that are explained = below"</FONT> </P> <BR> <P><FONT SIZE=3D2>Matt Adams</FONT> <BR><FONT SIZE=3D2>----</FONT> <BR><FONT SIZE=3D2>Matt Adams - GE Appliances - = matt.adams_at_appl.ge.com</FONT> <BR><FONT SIZE=3D2>It will make sense when you stop thinking = logically,</FONT> <BR><FONT SIZE=3D2>and start thinking Oracle-ly - Jim = Droppa</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Simon.Anderson_at_scisys.co.uk [<A = HREF=3D"mailto:Simon.Anderson_at_scisys.co.uk">mailto:Simon.Anderson_at_scisys= .co.uk</A>]</FONT> <BR><FONT SIZE=3D2>Sent: Wednesday, July 23, 2003 8:55 AM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Re: backwards export</FONT> </P> <BR> <P><FONT SIZE=3D2>I'm not sure of the export compatibility, but you = should know that 9i </FONT> <BR><FONT SIZE=3D2>clients won't talk to a 7.3.4 database, and 7.3.4 = clients won't talk to a </FONT> <BR><FONT SIZE=3D2>9.2 database, which could be a problem. At = least, they're not certified </FONT> <BR><FONT SIZE=3D2>to talk to each other, which isn't quite the same = thing.</FONT> </P> <P><FONT SIZE=3D2>Cheers</FONT> <BR><FONT SIZE=3D2>Simon Anderson</FONT> </P> <BR> <BR> <BR> <BR> <BR> <P><FONT SIZE=3D2>Jeroen van Sluisdam = <jeroen.van.sluisdam_at_vrijuit.nl></FONT> <BR><FONT SIZE=3D2>Sent by: ml-errors_at_fatcity.com</FONT> <BR><FONT SIZE=3D2>23/07/2003 12:49</FONT> <BR><FONT SIZE=3D2>Please respond to ORACLE-L</FONT> </P> <P><FONT SIZE=3D2> </FONT> <BR><FONT SIZE=3D2> = To: Multiple recipients of list ORACLE-L = <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=3D2> cc: = </FONT> <BR><FONT SIZE=3D2> = Subject: backwards = export</FONT> </P> <BR> <P><FONT SIZE=3D2>Hi,</FONT> <BR><FONT SIZE=3D2> </FONT> <BR><FONT SIZE=3D2>We are investigating possibilities for migration of = an oracle 7.3.4 to </FONT> <BR><FONT SIZE=3D2>oracle 9i. We want to separate our</FONT> <BR><FONT SIZE=3D2>production DB from the app-logic such that we can = migrate from oracle </FONT> <BR><FONT SIZE=3D2>7.3.4 on hp-ux 10.20 to oracle 9i</FONT> <BR><FONT SIZE=3D2>on hp-ux 11. Problem is our development and = test-environment because we </FONT> <BR><FONT SIZE=3D2>cannot separate the logic at the</FONT> <BR><FONT SIZE=3D2>same time here also from the db (costs). Does anyone = have any experience </FONT> <BR><FONT SIZE=3D2>with exporting from oracle 9i </FONT> <BR><FONT SIZE=3D2>to oracle 7.3.4 ? </FONT> <BR><FONT SIZE=3D2> </FONT> <BR><FONT SIZE=3D2>I found the underlying note on metalink about the = same problem but with </FONT> <BR><FONT SIZE=3D2>oracle 8. I have limited experience on = oracle8</FONT> <BR><FONT SIZE=3D2>and none on oracle 9. So I hope you can give some = tips.</FONT> <BR><FONT SIZE=3D2>..........................</FONT> <BR><FONT SIZE=3D2>You need to run the 7.3 version of export against = your 8.0 database via </FONT> <BR><FONT SIZE=3D2>sqlnet/net8. Beforehand, you need to run = rdbms/admin/catexp7.sql against </FONT> <BR><FONT SIZE=3D2>your 8.0 database. This creates the 7.3 export views = required. Note that </FONT> <BR><FONT SIZE=3D2>if you have used any 8.0 specific features (e.g. = objects) these will not </FONT> <BR><FONT SIZE=3D2>be exported for obvious reasons. </FONT> <BR><FONT SIZE=3D2>........................</FONT> <BR><FONT SIZE=3D2> </FONT> <BR><FONT SIZE=3D2>Tia,</FONT> <BR><FONT SIZE=3D2> </FONT> <BR><FONT SIZE=3D2>Jeroen</FONT> </P> <BR> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.net" = TARGET=3D"_blank">http://www.orafaq.net</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: </FONT> <BR><FONT SIZE=3D2> INET: Simon.Anderson_at_scisys.co.uk</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- = 858-538-5051 <A HREF=3D"http://www.fatcity.com" = TARGET=3D"_blank">http://www.fatcity.com</A></FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Mailing list = and web hosting services</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= ------</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =Received on Thu Jul 24 2003 - 10:19:26 CDT
 |
 |