nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Create Enterprise Geodatabase failure: Failed to setup st_geometry type.Failed to create the ST_Geometry metadata tables during install.

I'm trying to create an Enterprise Geodatabse in Oracle 11g hosted in an Exadata environment.

The message printed by the tool is: Failed to setup st_geometry type.Failed to create the ST_Geometry metadata tables during install.

The log generated is attached as sde_setup.log.

I've already checked the knowledgebade and based on this article I've run two sql queries:

SELECT OWNER, NAME, TYPE FROM DBA_DEPENDENCIES WHERE REFERENCED_NAME = 'ST_GEOMETRY' AND REFERENCED_TYPE = 'TYPE' AND TYPE = 'TABLE';
SELECT OWNER, TABLE_NAME, COLUMN_NAME FROM DBA_TAB_COLUMNS WHERE DATA_TYPE = 'ST_GEOMETRY'.

Both of them returns nothing.

sde_setup.log.zip

jcarlson_2-1637181289746.png

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

Hi !

Have you found the solution ? I have the same problem.

Thanks a lot.

As per article, query is as per below:

SELECT OWNER, NAME, TYPE FROM DBA_DEPENDENCIES WHERE REFERENCED_OWNER='MDSYS' AND REFERENCED_NA

ME = 'ST_GEOMETRY' AND REFERENCED_TYPE = 'TYPE' AND TYPE='TABLE';

Please run the above query as it is using "sys" login. This may help.

Thanks,

Biraja

Hi, this query returns nothing.

With this query :

SELECT OWNER, NAME, TYPE, REFERENCED_NAME, REFERENCED_TYPE FROM DBA_DEPENDENCIES WHERE REFERENCED_NAME = 'ST_GEOMETRY';

I have this result (see attachement)

Thanks.

query_result.csv.zip

Please run the below query and let us know your result:

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

Hi,

This query return nothing.

I have the same problem,how to solve it?

thanks

A customer has the same problem. Did you find a solution?
Thank you in advance!

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.