[ROL-1363] Migration Oracle database 3.0 to 3.1 partitialy failed

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1
• Fix Version/s: 3.1.1, 4.0
• Component/s: Installation & Configuration
• Environment: Oracle
• Assignee: David Johnson
• Reporter: Boris
• Created: 03/Mar/07 21:26
• Updated: 08/Jan/14 04:24
• Resolved: 01/Jul/07 03:26

Description

There is a bug in oracle db script: 300-to-310-migration.sql

– The rag_group_subscription table has been simplified and no longer needs a
– primary key but we don't want to drop the field just yet because that would
– make it impossible to abort a 3.1 upgrade and return to 3.0.
alter table rag_group_subscription drop id not null;
alter table rag_group_subscription drop id not null
*
ERROR at line 1:
ORA-00905: missing keyword

alter table rag_group_subscription drop primary key;