ArcGIS 无法创建SDE：Failed to setup st_geometry type.

报了类似的错误

could not create geodatabase tables and stored procedures

Failed to setup st_geometry type.Unable to load Type st_geometry, underlying DBMS error encountered.

找到解决办法：

http://support.esri.com/en/knowledgebase/techarticles/detail/38961

里面说由于有表引用到 st_geometry 导致 st_geometry 创建失败。

只需要执行这句sql：

SELECT OWNER, NAME, TYPE FROM DBA_DEPENDENCIES WHERE REFERENCED_OWNER='MDSYS' AND REFERENCED_NAME  = 'ST_GEOMETRY' AND REFERENCED_TYPE  = 'TYPE' AND TYPE='TABLE';

然后把查到的表drop和purge掉即可。