Home
The Toolkit for Online Communities
16699 Community Members, 2 members online, 2503 visitors today
Log In Register
OpenACS Home : Forums : OpenACS Development : Test install prerelease 5.4.2 on oracle : One Message

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

Collapse
Posted by Mario Aguado on
Hello Brian, I think, it is fixed on 5.4.2

The problem is 10.2 oracle release with temporary tables and clob columns.

You should drop the index for import or upgrade to 10.2 release.

Collapse
Posted by Brian Fenton on
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

Collapse
Posted by Mario Aguado on
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.

Collapse
Posted by Brian Fenton on
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

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