[
https://jira.duraspace.org/browse/DS-1370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hardy Pottinger reassigned DS-1370:
-----------------------------------
Assignee: Hardy Pottinger
> 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.0, 1.8.1, 1.8.2, 3.0
> Reporter: Robin Taylor
> Assignee: Hardy Pottinger
> 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
Dspace-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-devel
