backwards export

From: Jeroen van Sluisdam <jeroen.van.sluisdam_at_vrijuit.nl>
Date: Wed, 23 Jul 2003 12:50:02 +0200
Message-Id: <25998.339103@fatcity.com>

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.

------_=_NextPart_001_01C35108.2B0E6DE0
Content-Type: text/plain

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

------_=_NextPart_001_01C35108.2B0E6DE0
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">

<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 10">
<meta name=3DOriginator content=3D"Microsoft Word 10">
<link rel=3DFile-List href=3D"cid:filelist.xml_at_01C35118.E6ED9260">
<!--[if gte mso 9]><xml>
<w:WordDocument>

  <w:SpellingState>Clean</w:SpellingState>
  <w:GrammarState>Clean</w:GrammarState>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:HyphenationZone>21</w:HyphenationZone>
  <w:EnvelopeVis/>
  <w:Compatibility>
   <w:BreakWrappedTables/>
   <w:SnapToGridInCell/>
   <w:WrapTextWithPunct/>

<w:UseAsianBreakRules/>
</w:Compatibility>

  <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
 </w:WordDocument>

</xml><![endif]-->
<style>
<!--

/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal

	{mso-style-parent:"";
	margin:0cm;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:12.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;
	text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;
	text-underline:single;}
p
	{mso-margin-top-alt:auto;
	margin-right:0cm;
	mso-margin-bottom-alt:auto;
	margin-left:0cm;
	mso-pagination:widow-orphan;
	font-size:12.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";}
span.EmailStijl17
	{mso-style-type:personal-compose;
	mso-style-noshow:yes;
	mso-ansi-font-size:10.0pt;
	mso-bidi-font-size:10.0pt;
	font-family:Arial;
	mso-ascii-font-family:Arial;
	mso-hansi-font-family:Arial;
	mso-bidi-font-family:Arial;
	color:windowtext;}
span.SpellE
	{mso-style-name:"";
	mso-spl-e:yes;}
span.GramE
	{mso-style-name:"";
	mso-gram-e:yes;}
@page Section1
	{size:595.3pt 841.9pt;
	margin:70.85pt 70.85pt 70.85pt 70.85pt;
	mso-header-margin:35.4pt;
	mso-footer-margin:35.4pt;
	mso-paper-source:0;}
div.Section1
	{page:Section1;}

-->
</style>
<!--[if gte mso 10]>
<style>

/* Style Definitions */=20
table.MsoNormalTable

	{mso-style-name:Standaardtabel;
	mso-tstyle-rowband-size:0;
	mso-tstyle-colband-size:0;
	mso-style-noshow:yes;
	mso-style-parent:"";
	mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
	mso-para-margin:0cm;
	mso-para-margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:10.0pt;
	font-family:"Times New Roman";}

</style>
<![endif]-->
</head>

<body lang=3DNL link=3Dblue vlink=3Dpurple =
style=3D'tab-interval:35.4pt'>

<div class=3DSection1>

Hi,<o:p></o:p>

<o:p> </o:p>

We are investigating possibilities for migration of an oracle 7.3.4 to oracle 9i. We want to separate our<o:p></o:p>

production</fo= nt> DB from the app-logic = such that we
can migrate from oracle 7.3.4 on hp-ux = 10.20 to
oracle 9i<o:p></o:p>

on</spa= n> hp-ux 11.
Problem is our development and test-environment because we cannot = separate the
logic at the<o:p></o:p>

same</s= pan> time here also from the = db (costs).
Does anyone have any experience with exporting from oracle 9i
<o:p></o:p>

to</spa= n> oracle 7.3.4 ? =
<o:p></o:p>

<o:p> </o:p></sp= an>

I found the = underlying note on
metalink about the same problem but with =
oracle 8. I
have limited experience on oracle8<o:p></o:p>

and</sp= an> none on oracle 9. So I = hope you can
give some tips.<o:p></o:p>

<span lang=3DEN-US =
style=3D'font-size:12.0pt;

mso-ansi-language:EN-US'>...........................<o:p></o:p></span></=

font>

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. =
<o:p></o:p>

<span lang=3DEN-US =
style=3D'font-size:

10.0pt;font-family:Arial;mso-ansi-language:EN-US'>......................=

...<o:p></o:p>

<o:p> </o:p></spa= n>

Tia=
<font

size=3D2 face=3DArial>,<o:p></o:p>

<o:p> </o:p></spa= n> Received on Wed Jul 23 2003 - 05:50:02 CDT