jason.tipton.gis

Delete a feature class that ArcCatalog is unable to delete (Oracle)

Discussion created by jason.tipton.gis on Oct 1, 2015

Sometimes, you just can't delete a feature class from ArcCatalog. Maybe something got messed up in the database, or the feature class was incorrectly created. For whatever reason, ArcCatalog won't allow you to delete the feature class.

 

This is probably not the right way, but it's how I have had to do it (in Oracle):

 

set serveroutput on;


DECLARE 
  v_tbl     varchar(50) := 'RPT_REGION';         -- SET THIS TABLE
  v_schema  varchar(50);
BEGIN

  select sys_context('userenv','current_schema') into v_schema from dual;
  DBMS_OUTPUT.PUT_LINE(v_schema || '.' || v_tbl);
  DBMS_OUTPUT.PUT_LINE('DELETING FROM table_registry');
  DELETE FROM table_registry WHERE table_name = v_tbl;
  
  DBMS_OUTPUT.PUT_LINE('DELETING FROM column_registry');
  DELETE FROM column_registry  WHERE table_name = v_tbl;
  
  DBMS_OUTPUT.PUT_LINE('DELETING FROM layers');
  DELETE FROM layers  WHERE table_name = v_tbl;
  
  DBMS_OUTPUT.PUT_LINE('DELETING FROM geometry_columns');
  DELETE FROM geometry_columns WHERE f_table_name = v_tbl;
  
  DBMS_OUTPUT.PUT_LINE('DELETING FROM gdb_items');
  DELETE FROM gdb_items WHERE physicalname = v_schema || '.' || v_tbl;


  commit;
  
END;

 

Then Drop your table, and you can re-import it.

 

Branch of Re: ArcGIS Server 10.3 Question about deleting SDE feature class

Outcomes