Our SDE (10.0 on Oracle 11g) has a tabular view created from a feature class and a table. The view is valid in Toad but it does not show up in ArcCatalog for either the schema owner or the SDE user; arcpy.Exists() returns False. There is, however, an entry in the SDE.Table_Registry for the view. How can I remove this view from the table registry?
It would be best to contact ESRI Technical Support so they can verify the view is orphaned and can walk you through the process of removing all records in the repository tables.
I believe these orphaned table names in the Table_Registry were caused by dropping the table or view from Toad instead of ArcCatalog. After speaking with Esri support, they recommended cleaning this up by following these steps:
Basically, go through these six system tables and delete any rows that reference the object you are trying to delete.
In SQL Server if one of the database owners deletes a Geodatabase registered table or view with the SQL tools the same things happens but the fix is much cleaner. Simply create a dummy table of the same name using the SQL tools (Management Studio) and then go in and delete the table/view using ArcCatalog.
A dusty thread but I still found this very helpful. While I recently completed one of the ESRI SDE classes to get more familiar with the data model, this was a good summary. I had one of those orphan table pop up in table_registry. As a check for others, I ran a quick::
select A.table_name, B.name
from SDE_table_registry A
on A.table_name = B.name
where b.name is NULL
There can be any number of tables in your database (SQL Server in my case) but I'm thinking there shouldn't be anything in the registry tables that is not also in the system table.
Great idea Arne Gelfert. Here's the equivalent for us Oracle folks.
from SDE.table_registry A
left outer join ALL_TABLES B
on A.table_name = B.table_name
where b.table_name is NULL