[Spacewalk-list] Spacewalk schema upgrade 1.0 -> 1.1 fails

[Christoph Sievers]

Hi,

spacewalk-schema-upgrade fails with the following error:

SQL> CREATE UNIQUE INDEX rhn_sp_snep_uq
    ON rhnServerPackage (server_id, name_id, evr_id, package_arch_id)
    TABLESPACE USERS
    NOLOGGING;
  2    3    4      ON rhnServerPackage (server_id, name_id, evr_id,
package_arch_id)
       *
ERROR at line 2:



ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found


rgds
Christoph