'ORA-00955: name is already used by an existing object' for indexes on initial data load
Article ID: 84969
CA Automic Workload Automation - Automation Engine
Error Message :
'ORA-00955: name is already used by an existing object'
There are 'ORA-00955: name is already used by an existing object' for Indexes during the load initial data step of upgrades to the Automation Engine System.
Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition
Root Cause: This is due to implicit indexes becoming explicit indexes due to DB Operations (e.g. IMP/EXP, cloning of the DB etc.) but we are still handling them like implicit indexes.
Automation.Engine 10.0.7, Automation.Engine 11.1.3, Automation.Engine 11.2.1
- restore the DB Backup- drop indexes manually- run the DB Load again