From saurabhs@fcsltd.com Thu, 17 May 2001 23:38:28 -0700 From: "Saurabh Sharma" Date: Thu, 17 May 2001 23:38:28 -0700 Subject: Re: How to downgrade database from 8.1.5 to 8.0.6 - Urgent Help P Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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.  
----- Original Message -----
From: Djordje Jankovic To: 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.   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.   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):    

·         create a named pipe: $ mknod p_expimp p

·         export from the source database to the pipe: $ exp userid=src_username/password file=p_expimp OtherParameters

·         at the same time importing from the pipe is started: $ imp userid=trg_username/password file=p_expimp buffer=1024000 OtherParameters   Djordje

-----Original Message-----From: Helen rwulfjeq [mailto:lannyue@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!?Yahoo! Auctions $2 Million Sweepstakes - Got something to sell?