Error : Name is already used by an existing object while registering data with geodatabase

[wizgis]

Hi All,

We have an Oracle Geodatabase that we are able to connect to in ArcGIS Pro however, when trying to register it with geodatabase using the tool of Register With Geodatabase we are getting the error of : Name is already used by existing object. 

We are making sure that we are connected with Data Owner. 

Any inputs on this would be appreciated.

[CodyPatterson]

Hey @wizgis 

Observing this question: https://community.esri.com/t5/arcgis-pro-questions/create-enterprise-geodatabase-fails-ora-00955-nam...

Would you be able to show us the error as presented in the output of the tool and any associated errors? I believe this may be caused by a partial completion of the tool running on the database, but either failed part way through or similar.

Cody

[DavidPike]

I would check the database in Oracle and look for that table name, also the SDE system tables mentioned here:

Solved: Table Appearing in SDE, but deleted from SQL Serve... - Esri Community

(GDB_ITEMS, SDE_TABLE_REGISTRY, SDE_COLUMN_REGISTRY)

as you may have some ghost entries from incomplete deletions (e.g. a table previously deleted in Oracle SQL Developer rather than via ArcGIS - thus not clearing out the SDE/GDB system table entries).

Note also that tables can't share the same name even if they are within different Feature Datasets, as there is not Feature Dataset distinction within the database tables.

[VinceAngelo]

You have corrupted geodatabase metadata.

TLDR solution:

• Rename the table to a temporary name
• Create a dummy table (just objectid is enough) with the "existing" name
• Use ArcObjects (Pro UI or ArcPy) to delete the dummy table
• Rename the temp name back to original
• Register the no-longer "existing" table

- V