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

[Djordje Jankovic]

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:[EMAIL PROTECTED]]
Sent: Thursday, May 17, 2001 12:16 PM
To: Multiple recipients of list ORACLE-L
Subject: 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?