arcsde10.2导入shp时提示表已经被注册（table already registered）

-- 删除oracle arcsde中GIS_T1表，应该通过arcgis连接数据库后删除
-- 如果直接从oracle中drop，该表仍然在sde用户下存在元数据，再次导入会报错

-- 连接到sde数据库，查看元数据
SELECT * FROM LAYERS WHERE "OWNER" = 'GISDB' AND TABLE_NAME = 'GIS_T1';
SELECT * FROM TABLE_REGISTRY WHERE "OWNER" = 'GISDB' AND TABLE_NAME = 'GIS_T1';
SELECT * FROM COLUMN_REGISTRY WHERE "OWNER" = 'GISDB' AND TABLE_NAME = 'GIS_T1';
SELECT * FROM GEOMETRY_COLUMNS WHERE F_TABLE_SCHEMA = 'GISDB' AND F_TABLE_NAME = 'GIS_T1';
SELECT * FROM GDB_ITEMS WHERE "NAME" = 'GISDB.GIS_T1';

-- 删除元数据，通过arcgis重新连接数据库即可
DELETE FROM LAYERS WHERE "OWNER" = 'GISDB' AND TABLE_NAME = 'GIS_T1';
DELETE FROM TABLE_REGISTRY WHERE "OWNER" = 'GISDB' AND TABLE_NAME = 'GIS_T1';
DELETE FROM COLUMN_REGISTRY WHERE "OWNER" = 'GISDB' AND TABLE_NAME = 'GIS_T1';
DELETE FROM GEOMETRY_COLUMNS WHERE F_TABLE_SCHEMA = 'GISDB' AND F_TABLE_NAME = 'GIS_T1';
DELETE FROM GDB_ITEMS WHERE "NAME" = 'GISDB.GIS_T1';