Forum OpenACS Development: Re: Test install prerelease 5.4.2 on oracle
The diff is the fix. openacs doesn't need these temporary tables now.
If you need it you can drop the index and should be work. The problem is index in temporary tables for LOB datatype. Other index works.
My problem is I'm upgrading a very old OpenACS (version 4.7 I think) to use 10g database, so I get the error when I run an import.