Robin Taylor created DS-1370:
--------------------------------
Summary: Errors in Oracle db script
Key: DS-1370
URL: https://jira.duraspace.org/browse/DS-1370
Project: DSpace
Issue Type: Bug
Affects Versions: 1.8.2, 1.8.1, 1.8.0, 3.0
Reporter: Robin Taylor
Fix For: 3.0
Cut and pasted the following from an email from Kevin Gunn on dspace-tech...
*******************************************************************************************
Hi,
Just reporting some issues with the V1.8.2 scripts for oracle.
1- The script attempts to create index’s on the eperson table, these fail as
the fields are already indexed by have the UNIQUE constraint put on them in the
CREATE TABLE statement.
-------------------------------------------------------
-- EPerson table
-------------------------------------------------------
CREATE TABLE EPerson
(
eperson_id INTEGER PRIMARY KEY,
email VARCHAR2(64) UNIQUE,
password VARCHAR2(64),
firstname VARCHAR2(64),
lastname VARCHAR2(64),
can_log_in NUMBER(1),
require_certificate NUMBER(1),
self_registered NUMBER(1),
last_active TIMESTAMP,
sub_frequency INTEGER,
phone VARCHAR2(32),
netid VARCHAR2(64) UNIQUE,
language VARCHAR2(64)
);
-- index by email
CREATE INDEX eperson_email_idx ON EPerson(email);
-- index by netid
CREATE INDEX eperson_netid_idx ON EPerson(netid);
Results in the following errors.
table EPERSON created.
Error starting at line 143 in command:
CREATE INDEX eperson_email_idx ON EPerson(email)
Error at Command Line:143 Column:42
Error report:
SQL Error: ORA-01408: such column list already indexed
01408. 00000 - "such column list already indexed"
*Cause:
*Action:
Error starting at line 146 in command:
CREATE INDEX eperson_netid_idx ON EPerson(netid)
Error at Command Line:146 Column:42
Error report:
SQL Error: ORA-01408: such column list already indexed
01408. 00000 - "such column list already indexed"
*Cause:
*Action:
2- The clean up script is missing a DROP statement for the SEQUENCE
checksum_history_seq.
Cheers
Kevin
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
LogMeIn Central: Instant, anywhere, Remote PC access and management.
Stay in control, update software, and manage PCs from one command center
Diagnose problems and improve visibility into emerging IT issues
Automate, monitor and manage. Do more in less time with Central
http://p.sf.net/sfu/logmein12331_d2d
_______________________________________________
Dspace-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel
