Is it possible to add an Oracle Spatial View on QGIS MAP?

My view is registered on MDSYS metadata but, when I connect with Oracle DB, it is disabled on the list.

QGIS Desktop 2.2.0

Oracle Database 11g Enterprise Edition Release - 64bit Production
PL/SQL Release - Production
CORE      Production
TNS for 64-bit Windows: Version - Production
NLSRTL Version - Production

I assume you have not defined a SRID in the user_sdo_geom_metadata view? If not you can define the SRID in QGIS. When you get the list of layers, click on the SRID column for your view and then enter the desired SRID. The layer name should get enabled.


You also need to select the primary key, sometimes this isn't set on views

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.