Re: [Dspace-tech] ORA-01408 and ORA-00942 errors while installing Dspace 1.5.2 due to errors in database_schema.sql

2009-10-13 Thread Brouns, Francis
Hi all, The ORA-01408 errors seem to be caused because column (email) is defined with a Unique key constraint. Our DBA tells me that Oracle implements unique key constraints by creating an index (SYS_C007537). The create index statement than results in an error, because the unique index already

[Dspace-tech] ORA-01408 and ORA-00942 errors while installing Dspace 1.5.2

2009-10-09 Thread Brouns, Francis
Hi, We have been running Dspace with Postgresql for some years now. Our IT department would like to move to Oracle. I've been trying to do a fresh-install of Dspace 1.5.2 using an Oracle 10.2.2.0.2 database, on a SLES10 server. The Oracle database is located on a separate database server. The f