The oracle11g tag has no wiki summary.
1
vote
2answers
497 views
Querying intersecting areas areas - Oracle Locator or Spatial?
My spatial database is Oracle. We are wondering if we can use basic Oracle Locator or need to get the more expensive, full, Oracle Spatial.
My application's requirements include having to be able to ...
1
vote
0answers
33 views
How can I import data from an Oracle datapump into an empty Oracle SDE Geodatabase?
I have a SDE Geodatabase that contains empty layers created using ArcCatalog.
I'd like to import data into those layers from a datapump of an Oracle database that has the same structure as the empty ...
-1
votes
0answers
25 views
How to use sub queries while inserting record into db using cx_Oracle in python? [closed]
I need to add a symbol with the value of self.wrkArea variable like this
(select chr(182) from dual) || self.wrkArea || (select chr(182) from dual)
i.e. ¶workarea¶ will be the result. how to ...
0
votes
0answers
75 views
java.sql.SQLException: ORA-13226: interface not supported without a spatial index
I have created a spatial index on the column name and yet, I get an
java.sql.SQLException: ORA-13226: interface not supported without a spatial index
ORA-06512: at "MDSYS.MD", line 1723
...
2
votes
2answers
344 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
3answers
212 views
Shapefile import with Oracle + GeoServer produces points instead of vector shapes
I have implemented the example at http://www.gistutor.com/openlayers/22-advanced-openlayers-tutorials/47-openlayers-wfs-t-using-a-geoserver-hosted-postgis-layer.html and got it working properly.
Now ...
3
votes
1answer
197 views
ARCSDE for Oracle 11g Layer not found (-20)
I am using ARCSDE for Oracle 11g, with Oracle spatial database. I use the sdelayer command ot register my feature class. Surprisingly I get this error of Layer not found(-20) error. The table does ...
2
votes
1answer
336 views
Publishing oracle spatial table in geoserver
I published oracle view in geoserver. using this link. But when I see this in layer preview I get following xml response:
<?xml version="1.0" encoding="UTF-8" standalone="no"?><!DOCTYPE ...
1
vote
1answer
175 views
Open Source Challenge: Automated Mastermap update in Oracle Spatial
I've been set a challenge which is a bit out of my comfort zone. I'm an esri developer trying to break into the open source world.
I've been asked to automate the update of some oracle SDO datasets. ...
1
vote
0answers
46 views
Process to load elevation data into Oracle 11G
We have the National Elevation data set from USGS and considering loading it into Oracle (11G) database.
Can someone help with the process/steps?
1
vote
1answer
970 views
ArcSDE - Creating new install on new database with existing SDE schema
I asked a question before, but was probably not specific enough, so didn't get the information I required. My fault completely.
I am creating a new sde instance on a server. This needs to be pointed ...
4
votes
2answers
759 views
What is the best way to migrate an SDE Database
We have a prod database, with an SDE schema. We want to install a new SDE instance 9.3.1 and link it to a copy of the prod database.
ArcSDE 9.3.1 on Linux SLES 4
Now, what is the best way to do ...
4
votes
2answers
165 views
Migrating from FME Server 2008 (with Spatial Direct) to FME Server 2011
I am about to migrate a web app from it's old architecture to new. Part of this is migrating the old FME Server 2008 (using a Spatial Direct service) instance to FME Server 2011. I understand it is ...
