RE: How to downgrade database from 8.1.5 to 8.0.6 - Urgent Help P

From: Djordje Jankovic <djankovic_at_corp.attcanada.ca>
Date: Thu, 17 May 2001 09:29:27 -0700
Message-ID: <F001.003065E6.20010517092600@fatcity.com>

The
safest way is to do a full database export, to create a new 8.0.6 database instance and to import the data in the new database.  You have to see for inter-version specifics - you might need to use 8.1.5 import version to import in the 8.0.6 database - you have to check that, but it is for sure doable.
<SPAN

class=293381916-17052001> 
If at
all possible, I would not delete the original 8.1.5 database before I am fully done with the import and I test that 8.0.6 is working fine.
<SPAN

class=293381916-17052001> 
If you
do not have enough space for 8.1.5 + export file + 8.0.5 (and you are on unix) you might use the named pipes for export/import (again make sure that the exp/imp versions are OK):
<SPAN

class=293381916-17052001> 
 
<P class=BodyCopy

style="MARGIN-LEFT: 0.25in; TEXT-INDENT: -0.25in; mso-list: l5 level1 lfo12; tab-stops: list .25in"><SPAN 
style="FONT-FAMILY: Symbol">·<SPAN 
style="FONT: 7pt 'Times New Roman'">         

create a named pipe:
$ mknod p_expimp p
<P class=BodyCopy

style="MARGIN-LEFT: 0.25in; TEXT-INDENT: -0.25in; mso-list: l22 level1 lfo13; tab-stops: list .25in"><SPAN 
style="FONT-FAMILY: Symbol">·<SPAN 
style="FONT: 7pt 'Times New Roman'">         

export from the source database to the pipe: $ exp userid=<I

style="mso-bidi-font-style: normal">src_username/<I 
style="mso-bidi-font-style: normal">password file=p_expimp <I 
style="mso-bidi-font-style: normal">OtherParameters

<P class=BodyCopy

style="MARGIN-LEFT: 0.25in; TEXT-INDENT: -0.25in; mso-list: l30 level1 lfo14; tab-stops: list .25in"><SPAN 
style="FONT-FAMILY: Symbol">·<SPAN 
style="FONT: 7pt 'Times New Roman'">         

at the same time importing from the pipe is started: $ imp userid=<I

style="mso-bidi-font-style: normal">trg_username/<I 
style="mso-bidi-font-style: normal">password file=p_expimp buffer=1024000 <I 
style="mso-bidi-font-style: normal">OtherParameters

<SPAN

class=293381916-17052001> 
<SPAN

class=293381916-17052001>Djordje
<BLOCKQUOTE

style="BORDER-LEFT: #0000ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">   <FONT face=Tahoma
  size=2>-----Original Message-----From: Helen rwulfjeq   [mailto:lannyue_at_yahoo.com]Sent: Thursday, May 17, 2001 12:16   PMTo: Multiple recipients of list ORACLE-LSubject: How   to downgrade database from 8.1.5 to 8.0.6 - Urgent Help   Please!
  Hello:
  Please help me on this crisis! What is the steps and safe procedures to   downgrade database from 8.1.5 to 8.0.6 ??? I need to have this done by noon   today.
   I have database 8.1.5 with all schemas and data. But the application   can not support 8.1.5.  I have to install 8.0.6.(new   one)   Then I need get all those data and schemas into 8.0.6.   I know in some way this can be done, Now matter how risk I   have to do at client's request.
  What is the steps and safe procedures???   Thanks in advance      

  Do You Yahoo!?<A
  href="rd.yahoo.com/auctions/tag/?http://promotions.yahoo.com/promotions/yahooauctions/index.html">Yahoo!   Auctions $2 Million Sweepstakes - Got something to sell? Received on Thu May 17 2001 - 11:29:27 CDT