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 exists.
The failure to create the WorkflowItem and TasklistItem tables seem to be caused by the empty lines in the statement. ------------------------------------------------------- -- WorkflowItem table ------------------------------------------------------- CREATE TABLE WorkflowItem ( workflow_id INTEGER PRIMARY KEY, item_id INTEGER REFERENCES Item(item_id) UNIQUE, collection_id INTEGER REFERENCES Collection(collection_id), state INTEGER, owner INTEGER REFERENCES EPerson(eperson_id), -- Answers to questions on first page of submit UI multiple_titles NUMBER(1), published_before NUMBER(1), multiple_files NUMBER(1) -- Note: stage reached not applicable here - people involved in workflow -- can always jump around submission UI ); CREATE INDEX workflow_coll_fk_idx ON WorkflowItem(collection_id); CREATE INDEX workflow_owner_fk_idx ON WorkflowItem(owner); ------------------------------------------------------- -- TasklistItem table ------------------------------------------------------- CREATE TABLE TasklistItem ( tasklist_id INTEGER PRIMARY KEY, eperson_id INTEGER REFERENCES EPerson(eperson_id), workflow_id INTEGER REFERENCES WorkflowItem(workflow_id) ); CREATE INDEX tasklist_eperson_fk_idx ON TasklistItem(eperson_id); CREATE INDEX tasklist_workflow_fk_idx ON TasklistItem(workflow_id); ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
