Forum OpenACS Development: Re: Test upgrade dotlrn from 2.3.1 to dotlrn-2-4-0a1 on Oracle

Thaks Emmanuelle and Don.

I repeated the update process with changes made by Daveb and what I changed on sweep-procs-oracle.xql and category-tree-package.sql.

The update proccess was ok.
I have commited my changes on cvs.

I saw one problem with install on oracle 10G. Only is for this version of ORACLE. The problem is that oracle 10.2 add a restriction with index on temporaty tables and the index cann't create. "Now a domain index cannot be created on temporary table".
The error is:

create index cr_doc_filter_index on cr_doc_filter ( content )
                                    *
ERROR at line 1:
ORA-29918: cannot create domain indexes on temporary tables