HOW TO

Clean up detached records in the SDE repository tables using ArcCatalog

Last Published: April 30, 2021

Summary

Note:
This article pertains to ArcGIS versions 9.x only. Later versions of ArcGIS may contain different functionality, as well as different names and locations for menus, commands and geoprocessing tools.
Note:
ArcSDE software, including the application server, command tools, and SDK with C and Java APIs, was deprecated at ArcGIS 10.2.2 and is no longer distributed.

If ArcCatalog closes prematurely while deleting or creating a feature class, it can leave detached entries in the SDE repository tables.

When the business table is deleted in ArcCatalog, the feature class fails to appear in the table of contents.

Procedure

To clean up entries in the SDE repository tables, perform the steps below using the following example of a deleted feature class: joe.roads.

  1. In Query Analyzer (SQL Server) or Sqlplus (Oracle), create a table by the name of 'roads' and 'joe' as the name of the user. The table name should be the exact name as the deleted table and this should be created by the original data owner.
  2. Make a spatial database connection as user 'joe' in ArcCatalog.
  3. The roads feature class now appears in the table of contents in ArcCatalog. Right-click it and select 'delete'.

Article ID: 000009712

Software:
  • ArcMap 9 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options