The oracle11g tag has no wiki summary.
6
votes
0answers
58 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 ...
1
vote
0answers
46 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 ...
0
votes
0answers
118 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
...
1
vote
0answers
54 views
How to add a column to table with sdelayer command?
I am working with an oracle11g database and I would like to add a new column to a feature class stored in this database. I would like to use the sdelayer command but can any one of you give me a tip ...
3
votes
3answers
230 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 ...
1
vote
2answers
546 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 ...
2
votes
2answers
365 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
1answer
207 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
355 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
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
1k 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
814 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 ...
1
vote
1answer
176 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. ...
4
votes
2answers
167 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 ...
