Questions tagged [oracle-11g]

Oracle is an RDBMS product. Specific releases of the product are known as Oracle9i, Oracle10g and Oracle 11g. Generally there are two releases within each major version. Questions tagged oracle11g are assumed to be specific to this version or features introduced in this version.

Filter by
Sorted by
Tagged with
3
votes
1answer
4k views

Connecting to Oracle database with ArcGIS for Desktop?

I installed ArcGIS 10.2.2 ,oracle 11g R2 personal edition and it's client.I try to connect to the database using database connection in ArcMap but the error Failed to connect to the specified ...
12
votes
1answer
4k views

How to trace SQL queries sent by ArcGIS Server (ArcSDE) to Oracle database?

I'd like to generate a log file containing all SQL queries sent by ArcGIS Server (ArcSDE) to Oracle database. Is there a way to do so? I'm using Oracle 11g and ArcGIS Server 10.0 on Windows. ArcSDE is ...
4
votes
4answers
2k views

Exporting data from Oracle to Esri File Geodatabase grid size error

My specs: ArcInfo 10.1, Oracle 11g I have a line dataset which is sat in Oracle 11g. I can read/query/symbolise this in ArcDesktop without any problems. I now want to export a selection into a file ...
5
votes
2answers
739 views

Creating geodatabase (and st_geometry) in Oracle Express (XE) for home/personal use?

I'd like to set up a database environment at home that mimics what I have in the office (Oracle enterprise geodatabase/ESRI's st_geometry). I want to do this for spatial database training purposes in ...
5
votes
3answers
5k views

Error exporting data from Oracle to shp using ogr2ogr

I have an oracle table which I would like to query/make a selection. I would then like to export the selection to a shp file. I'm using gdal and ogr2ogr. Following the guidelines here and here I ...
2
votes
2answers
1k views

Is ArcMap 10.0 Query Layer passing invalid SQL to Oracle 11gR2?

In two different environments I'm having trouble using ArcMap 10.0 Query Layers to view SDO_GEOMETRY (point) data in Oracle 11.2. This suggests I'm doing something wrong... Points are in Oracle ...
3
votes
0answers
435 views

GeoServer 2.9.2 database connection pooling/thread locking issue

I am mocking GetMap requests. Scenario is that 50 users use only "database layers". Each user "sends" 8 GetMap requests every ~22s for ~300s which sums up to 5200 GetMap requests for vector data. ...
1
vote
0answers
747 views

Spatial query by ESRI ST_Geometry take too long

I am using ESRI ST_Geometry in my application, and I found that the spatial query is rather slow: The following sql is used for query pois inside a certain bounding_box: select * from ( select ...