[
https://jira.duraspace.org/browse/DS-1370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ivan Masár updated DS-1370:
---------------------------
Status: Open (was: Received)
> 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
------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
Dspace-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel
