1

I can connect to the Oracle Database with QGIS but spatial table/layers are not recognized as such.

I have read the following in the QGIS documentation:

Normally, an Oracle Spatial layer is defined by an entry in the USER_SDO_METADATA table. Source: QGIS Oracle connection documentation

But I have not found this in the database and I cannot edit it.

The layers were created with ArcMap (so with ArcSDE). I know under ArcMap the spatial layers are recognized. I found that the following tables has informations about spatial tables:

enter image description here enter image description here

Is it an option to overwrite USER_SDO_METADATA table ?

2

As commented by @Vince:

To the best of my knowledge, QGIS doesn't read SDE.ST_GEOMETRY, which won't have an entry in USER_SDO_GEOM_METADATA. You'd need to change your enterprise geodatabase configuration to use SDO_GEOMETRY then recreate the table before QGIS can see the table. It would be unwise to let QGIS modify rows in a versioned feature class.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.