'ORA-00955: name is already used by an existing object' for indexes on initial data load
book
Article ID: 84969
calendar_today
Updated On:
Products
CA Automic Workload Automation - Automation Engine
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.
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.