在oracle中删除sde导入的shp数据。

 

 导入一个shp后，会新增三个表，修改多个表和添加一些其他的限制。

   select  able testlhh1;

    select * from table_registry where table_name = upper('testlhh1')
    select * from geometry_columns where f_table_name=upper('testlhh1')
    select * from layers where table_name = upper('testlhh1')
    delete 549F 和 549S
    select * from gdb_objectclasses where name = 'testlhh1'
    
    
   
    
    //实际操作如下：
      drop table testlhh1;
      delete from table_registry where table_name = upper('testlhh1');
      delete from geometry_columns where f_table_name=upper('testlhh1');
     delete from layers where table_name = upper('testlhh1');
     drop table F549 ;
     drop table S549;
     delete from gdb_objectclasses where name = 'testlhh1';
     commit;