Forum OpenACS Q&A: Re: How to upgrade Oracle from 8.1.7.0 to 8.1.7.4 ?

Collapse
Posted by Bruno Mattarollo on

Hello,

I have downloaded the patch to get my version to 8.1.7.4 (running on Linux) and tryied to do an export from an openacs installation (user == arsdigita) and import it back under another user. I tried:

imp development/**** file=oraexp20030205.dmp fromuser=arsdigita touser=development

with no success, Oracle keeps complaining that the tablespace ARSDIGITA does not exist.

I deleted the tablespace arsdigita because I need this to test our procedure to get an export from our production database into our development and staging ones but since those are residing on the same Oracle server, I need to import them in different tablespaces and I can't seem to be able to.

This seems like one of the bugs that should have been solved by 8.1.7.4, right?

Has anyone been succesful in doing this? Do you have some pointers?