Description of problem:

While upgrading satellite server schema from Satellite with external Oracle database to version 5.6, schema upgrade failed with:

'SATELLITE-SCHEMA-5.4-TO-SATELLITE-SCHEMA-5.5/208-RHNERRATACLONED-INDEXES.SQL.ORACL
-----------------------------------------------------------------------------------
satellite-schema-5.4-to-satellite-schema-5.5/208-rhnErrataCloned-indexes.sql.oracle

drop index rhn_errataclone_teid_feid_idx
           *
ERROR at line 1:
ORA-02429: cannot drop index used for enforcement of unique/primary key

Version-Release number of selected component (if applicable):
Satellite 5.6

How reproducible:
(uncertain, like with the other similar bugs (987183, 877299, or 875672) the error occurs with only some external Oracle instances, and not yet replicated in-house)

Steps to Reproduce:
1. Upgrade Satellite 5.3 with external Oracle database to Satellite 5.6
2.
3.

Actual results:
Fails with error above.

Expected results:
Succeeds.

Additional info:
This is similar to the other known issues for similar indexes (rhn_eclonedtmp_teid_feid_idx, rhn_ug_id_name_org, rhn_sg_id_oid_name_idx), please refer to Knowledgebase solution for details and workaround https://access.redhat.com/site/solutions/228683

Please note that if customer is running into the same ORA-02429 error but with another object not listed on the above solution, file a new Bugzilla from the support case so it can be looked into, confirmed whether the same workaround applies, and addressed properly.