(Using ArcGIS 10.8.1 and Oracle 19c)
I'm trying to unregister some older feature class tables (legacy ESRI Binary geometry) from our geodatabase, since they all have newer ST_GEOMETRY counterparts (either as standalone or as part of a view), as a means of avoiding confusion with the end users as to which is correct.
What I'm basically trying to do is to get the (legacy) table to be viewed by Catalog as a table and no longer as a feature class.
As I've researched, post-SDE, I don't think there's a straight way to unregister something (these are unversioned), so what I was going to try and do, is run a delete on the sde owned tables and possibly also null out the shape column:
delete
from SDE.table_registry
where owner = 'myschema'
and table_name = 'myfeature';
delete
from sde.column_registry
where owner = 'myschema'
and table_name = 'myfeature';
delete
from sde.layers
where owner = 'myschema'
and table_name = 'myfeature';
delete
FROM sde.geometry_columns
WHERE f_table_schema = 'myschema'
AND f_table_name = 'myfeature';
UPDATE myschema.myfeature
SET SHAPE = NULL;
I've tried it on a test case and it still somehow shows up as a (blank) FC in Catalog, so I'm guessing that there's some place else that still recognizes it as registered.
Is there anything else that I would need to do in addition, or instead of this route?