Forum OpenACS Q&A: Re: Improvements for OpenACS Oracle install docs

Posted by Andrew Piskorski on
Tom, there is a long list of bugs in that fixes. The one in particular that bit me was an import bug that basically makes it impossible to import to a different schema. See this thread.

The patch will convert an existing database. That worked fine for us on Solaris, but on Linux I've only installed the patch before creating a database. Since you have no data in your db, I'd probably blow it away and create it again from scratch after doing the patch, but it should work to upgrade in place, too.

For removing a tablespace, see this post, and/or some (already outdated, naturally) Oracle docs I put on my website.