Re: [Qgis-user] connection to Oracle 11.2.0.4.0 without spatial

[gprocino]

Dear all,
I've installed Oracle Spatial:
-
/SELECT USERNAME,TO_CHAR(CREATED,'DD-MON-YY HH24:MI:SS')
CREATED,ACCOUNT_STATUS,DEFAULT_TABLESPACE 
FROM DBA_USERS ORDER BY 2;
….
MDSYS
25-FEB-16 01:04:40
EXPIRED & LOCKED ORA_SPATIAL
 
SQL> select version, status from dba_registry where comp_id='ORDIM';
 
VERSIONSTATUS
-- -
11.2.0.4.0 VALID
 
1 riga selezionata.
SQL> select comp_id,version,status from dba_registry
  2  where comp_id in ('JAVAVM','ORDIM','XDB');
 
COMP_IDVERSION
-- --
STATUS
-
ORDIM  11.2.0.4.0
VALID
 
XDB11.2.0.4.0
VALID
 
JAVAVM 11.2.0.4.0
VALID
 
 
Selezionate 3 righe./
---

Now when I try to connect to Orable the same error appear:
-ORA-04043: object MDSYS.SDO_GEOMETRY doesn't exist. Impossibile
connettersi.

Could you give me some advices?
Thanks in advance.

Giuseppe





--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/connection-to-Oracle-11-2-0-4-0-without-spatial-tp5251693p5252964.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] connection to Oracle 11.2.0.4.0 without spatial

[gprocino]

Dear all,
I'm trying to connect qGIS 2.12 to Oracle without spatial extention.

Using the oracle connection window the following error appear:
 

Can I connect to Oracle that haven't spatial extention?

Note that I have checked "show also the table without geometry" option
within the window connection.

Are there other way to get oracle table within qGIS?

Thanks
Giuseppe




--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/connection-to-Oracle-11-2-0-4-0-without-spatial-tp5251693.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user