[Qgis-user] connection to Oracle 11.2.0.4.0 without spatial

gprocino gprocino at planetek.it
Fri Feb 26 01:22:21 PST 2016


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';
 
VERSION                        STATUS
------------------------------ ---------------------------------
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_ID                        VERSION
------------------------------ ------------------------------
STATUS
---------------------------------
ORDIM                          11.2.0.4.0
VALID
 
XDB                            11.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.



More information about the Qgis-user mailing list