Forum OpenACS Development: Re: Test install prerelease 5.4.2 on oracle


	The Toolkit for Online Communities 15901 Community Members, 1 member online, 2319 visitors today			Log In	Register

Forum OpenACS Development: Re: Test install prerelease 5.4.2 on oracle

OpenACS Home : Forums : OpenACS Development : Re: Test install prerelease 5.4.2 on oracle : One Message

Back to OpenACS Development

9: Re: Test install prerelease 5.4.2 on oracle (response to 8)

Posted by Brian Fenton on 12/03/08 10:41 AM

Hola Mario!

thanks but I'm a little confused - that diff you linked to shows the index and temporary table removed - is that the fix? Do we not need the index and temporary table?

Oracle recommend changing the temporary table to a permanent one, or creating a different type of index.

thanks
Brian

10: Re: Test install prerelease 5.4.2 on oracle (response to 9)

Posted by Mario Aguado on 12/03/08 11:18 AM

Hi Brian,

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.

11: Re: Test install prerelease 5.4.2 on oracle (response to 10)

Posted by Brian Fenton on 12/03/08 01:46 PM

Ah ok, I understand now. Thanks for explaining.

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.

Gracias!

Brian

12: Re: Test install prerelease 5.4.2 on oracle (response to 11)

Posted by Mario Aguado on 12/03/08 06:52 PM

you should drop the index only and export again. The problem could be search then. Sorry by I don't know intermedia tool.

Back to OpenACS Development