At our institution we are working with (Dspace 1.3.2 with Oracle 9) located at
http://dspace.uah.es/dspace and we haven't modified the schema locally.
Last Wednesday (6/27) tried to update of Dspace 1.3.2 to Dspace 1.4.2 but we
had problems with the updating of database. When we ran the SQL script for
Oracle "database_schema_13-14.sql" gave error because this script has some
errors as:
- CREATE SEQUENCE tasklistitem_seq (This sequence exist in the release 1.3.2)
- The function setval is invalid for Oracle.
- In Oracle the type VARCHAR needs to put the byte number.
- The sentence "date_trunc('milliseconds', now()" is invalid for Oracle.
.................
However the "database_schema1.4-142.sql" is correct.
Brian Helstien in the message 2007-06-19 reports the Oracle error log. We don't
know if there is "database_schema_13-14.sql" for Oracle correct in somewhere to
download.
Regards,
M. JOSE GOMEZ
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech