for downgrading from oracle 8 to 7, u need to take
complete export and import the file in oracle 7 by running the catexp7.sql
utility.
look for more help on this utility.
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
- Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
<A href="mailto:djankovic_at_corp.attcanada.ca"
title=djankovic_at_corp.attcanada.ca>Djordje Jankovic
To: <A href="mailto:ORACLE-L_at_fatcity.com"
title=ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L
Sent: Thursday, May 17, 2001 10:56
PM
Subject: RE: How to downgrade database
from 8.1.5 to 8.0.6 - Urgent Help P
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>
<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 <FONT
size=2>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 Fri May 18 2001 - 01:38:28 CDT