Return
-
Title
Error upgrading user: "ORA-00955: name is already used by an existing object" -
Description
After upgrading Spotlight to version 6.0, the user encounters the following error when trying to upgrade the schema objects on the database:
An error has occurred in table SoOTables in connection <connection> with the following error:
ORA-00955: name is already used by an existing object
ORA-06512: at line 207
in table SooTables -
Resolution
Drop the Spotlight database user with cascade option and re-install the objects by going to File | Oracle User Wizard.