'ORA-00955: name is already used by an existing object' for indexes on initial data load
Article ID: 84969
Updated On:
Products
CA Automic Workload Automation - Automation Engine
AUTOMIC WORKLOAD AUTOMATION
Issue/Introduction
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.
'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.
Cause
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.
Environment
Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition
Component:
Component:
Resolution
Fix Version(s):
Automation.Engine 10.0.7, Automation.Engine 11.1.3, Automation.Engine 11.2.1
Automation.Engine 10.0.7, Automation.Engine 11.1.3, Automation.Engine 11.2.1
Additional Information
Workaround :
- restore the DB Backup- drop indexes manually- run the DB Load again
- restore the DB Backup- drop indexes manually- run the DB Load again
Feedback
Powered by
