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.

learn more… | top users | synonyms

0
votes
0answers
18 views

Export to Oracle using QGIS

I have loaded a shapefile into QGIS and I now want to export it into our Oracle Database and add SDO_GEOMETRY. Is it possible to do this directly in QGIS? If not, what opensource options do I have to ...
0
votes
0answers
30 views

Unable to create multiversion view in ArcSDE 10.2 and Oracle 11g

I couldnt create a multiversion view using 10.2. I registered feature dataset as versioned, it created MV view for one class but didnt create the MV view for the other one. Even I tried creating the ...
1
vote
1answer
71 views

How to configure ST_GEOMETRY Access for Oracle 64 bit?

I'm trying to configure the Oracle extproc to access the geodatabase with SQL, using the documentation here. This is a Windows 2008 R2 server with 64 bit, and the Oracle server is also 64 bit. I'm ...
4
votes
0answers
65 views

ArcObjects : Out of Server Memory when reconciling a large edit session

One of our users has been periodically experiencing 'Out of Server Memory' errors with ArcSDE 10.0 when trying to reconcile a large edit session. VMware ESX Instance: Windows Server 2008 R2 ...
2
votes
1answer
121 views

How do you determine which dbclient connection property to use for an Oracle SQLWorkspace connection?

I have an Oracle11g database that I connect to via a SQL Workspace; however the actual dbclient string value that works differs depending on machine (and I'm guessing oracle client configuration). On ...
1
vote
2answers
231 views

Why using multiversioned views?

I don't see the reason why multiversioned views exist. It's not possible to use joins like in normal views. And editing versions is possible by directly using the feature class itself. So when am I ...
2
votes
2answers
254 views

How to copy selected features from one sde feature class to another with different attributes using Arcpy?

I am new to Arcpy scripting, I need help on copying the features to SDE feature class. My Scenario: We have 2 Geo databases running on Oracle 11g ArcSDE 10.2 . I have been asked to write the python ...
2
votes
2answers
138 views

Finding Polygons which do not touch any other polygon in a single oracle database table

I currently have an oracle table of approximately 100,000 records - all of which are polygons. I want to find all the polygons which do not touch any other polygon within the same table. There are a ...
1
vote
1answer
72 views

Interpolate points to lines every odd and even number

We are working in Oracle Database 11g. There is a table with sdo_geomerty column(representing a line) which contains the following : RSID, LT, LF, GEOM 584908, 30, 34, ...
1
vote
0answers
198 views

How to use the same client for Oracle 8 and Oracle 11g?

I have a legacy system into Oracle 8, and spatial database in Oracle 11g. When I installed the Instant Client for Oracle Spatial access to Oracle 8 did not work. My question is how can I do to be able ...
3
votes
2answers
409 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 ...
1
vote
1answer
44 views

QGIS 2.2 crashes when saving digitized data in ArcSDE 10.1

I am using QGIS 2.2 with ArcSDE 10.1 for Oracle 11gR2 I have created a polygon feature class with SDO_geometry, when trying to save the digitized data QGIS crashes. Please help, I want to edit the ...
2
votes
0answers
38 views

Why are ellipse polygones simplified when used in a FeatureService?

I have polygons with ellipse shape in a SDE Oracle ST_GEOMETRY geodatabase. All those polygons are correctly displayed when in a MapService. But when displayed in a FeatureService, some polygons ...
2
votes
0answers
80 views

ODBC connection issue on 64bit architecture

I'm migrating an addin to a 64bit machine using Arcmap 9.3.1. Upon execution, it returns the following error - "[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch ...
1
vote
1answer
109 views

Why a severe performance difference using deleteSearchedRows

The issue I am having involves two versioned tables. A function deletes 48 rows from Table A and and 48 rows from Table B using deleteSearchedRows. However, the delete from Table A takes roughly 4 ...
4
votes
2answers
408 views

Failed to connect to the specified server, ArcGIS 10.1 connection using Oracle 11 g

I am trying to connect an Oracle 11g database to ArcGIS 10, but it's not working and gives the following error: "Failed to connect to the specified server. Operation Failed." While I am sure about ...
0
votes
1answer
58 views

Issues while changing ArcSDE from a Workgroup to Domain Environment

Our organisation was a having a multi-user Geodatabase ( ArcSDE 10.1 gateway on an Oracle 11 g DB) in a Workgroup configuration. The type of Authentication for DB connection was "Database ...
0
votes
0answers
35 views

ArcGIS 10.1 MakeTableView doesn't filter records

I'm running ArcGIS10.1 on Win7 64bit with Oracle 11g and I'm having trouble with database table connections in Oracle. In Modelbuilder I use the MakeTableView tool and apply a filter expression so ...
2
votes
1answer
237 views

how do you manage columns in an ArcSDE/Oracle feature class?

Our enterprise has a long history with Oracle and ArcSDE. And lots of tension between the Oracle people and GIS people. Oracle folk often don't like the requirement of using expensive 'nonstandard' ...
2
votes
0answers
197 views

Geodatabase Connection to Oracle Active Data Guard Standby

Thank you in advance for any help you can provide. ENVIRONMENT Database Server: Oracle 11.2.0.2.0 Single-Instance Database on Windows Server 2003 R2 Enterprise 64-bit Oracle Active Data Guard for ...
0
votes
2answers
261 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 ...
4
votes
2answers
658 views

Is there a SDE command to export/import feature class schema only without data?

I'm using ArcGIS Server 10.0, ArcSDE 10.0 and Oracle 11g. I'd like to create a sde export of my layers' schema. The export would be used to create easily those layer in a new database instance. Do ...
2
votes
1answer
160 views

How to register table with geodatabase with a command line?

Is there a way to register with geodatabase a table stored in an Oracle 11g database, without using ArcMap or Python script? I'd like to do it with a command line like when registering with ArcSDE ...
2
votes
1answer
159 views

Moving Versioned Data between different geodatabases

Can you please let me know how to migrate feature class which is registered as version and archiving is enabled on it From: Database Environment: ArcSDE 9.3, RHEL 5, Oracle 11.2.0.2 To Database ...
4
votes
1answer
282 views

ArcGIS Server and Oracle SDO Geometry Interop - It Can't Be This Slow

I have an ArcGIS Map Server Map Service connecting to an Oracle 11G instance via Direct Connect. There is no need for ArcSDE since our application doesn't need versioning, replication, or any other ...
2
votes
0answers
70 views

Can .Net version of ArcGIS Server expose Oracle spatial data without ArcSDE, or is this limited to Java version?

I'm planning a new deployment of ArcGIS Server and I want to avoid using ArcSDE if possible. My vendor requires that we store our spatial data in Oracle and we prefer to use Microsoft server ...
1
vote
0answers
130 views

ESRI Versioning: A table doesn't match base table schema

ArcGIS 10.1 sp1 with Oracle 11g I've got a versioned feature class that I have discovered has a base table with a different schema than the corresponding A table. (A + registration_id from ...
3
votes
1answer
3k views

ArcSDE 10.2: How to enable and create Geodatabase in Oracle without ArcGIS Desktop

Since there is no Post Installation Wizard anymore in ArcSDE 10.2 - how can i enable und create a geodatabase in oracle without ArcGIS Desktop? We have only an EDN description for ArcGIS Server/SDE, ...
7
votes
1answer
1k 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
1answer
359 views

Importing data from Oracle Data Pump into empty Oracle ArcSDE Geodatabase?

I have an ArcSDE Geodatabase that contains empty layers created using ArcCatalog. I would like to import data into those layers from a Data Pump of an Oracle database that has the same structure as ...
1
vote
1answer
280 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
511 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
2k 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
826 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
380 views

Resolving ArcSDE for Oracle 11g Layer not found (-20) error?

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
760 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
57 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
2k 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
2k 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
210 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
205 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 ...