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 (1)

2
votes
2answers
68 views

Creating spatial view from materialized view?

I have a materialized view that runs nightly and performs an intersection of point locations and polygons. The materialized view works as designed and returns the desired results. It contains ...
0
votes
0answers
26 views

ArcSDE 10.1 Insert/Update Trigger on Adds (A) Table (Oracle 11g) and Feature Services on ArcGIS Server

I'm trying to use a trigger to update a versioned dataset in an SDE environment. Basically, I wanted to implement a system of unique ids called GISID. Initially, when a feature is created (inserted), ...
3
votes
1answer
34 views

Projection Problem on Oracle Spatial

I would like to transform SDO_GEOMETRY from WGS84 projection to my custom projection in Oracle Database. Details for custom projection is as follows: +proj=lcc +lat_1=40.5 +lat_2=37.5 +lat_0=25 ...
2
votes
2answers
37 views

Do I need to use ESRI's Create Spatial Type functionality

Does anyone know if I need to use ESRI's Create Spatial Type functionality when creating a field in a non ESRI / non geodatabase Oracle 11g database? I have an older customer database in Oracle. ...
2
votes
0answers
26 views

Controlling precision of coordinates returned from ArcGIS for Server service?

I have a REST service that returns shapes as json. The shapes represent various natural features. The problem is the precision of the coordinates. Currently, 11 decimal places of precision are ...
2
votes
1answer
48 views

Esri ArcSDE 10.3.1 Query Inspire Metadata from Oracle (11g) Enterprise GeoDB via SQL

As the title says - I want to create a query in Oracle SQL which will read all dates from the geoprocessing history which can be found using ArcCatalog to show the "Description"-tab from a feature. ...
1
vote
1answer
53 views

ArcMap 10.3.1 Editor Message: “A layer for PROJECT_LINES was not found…”

When editing a feature class stored in Oracle Spatial, I am receiving 3 warning messages upon stopping the edit session: There are 2 more after pressing OK - PROJECT_POINTS and PROJECT_POLYGONS. I ...
0
votes
0answers
17 views

Is it possible to use oracle map viewer editor in map viewer javascript api?

I'm new in oracle spatial mapviewer.I want to create a simple webGIS using oracle map viewer and javascript api with editing tool. I read about editor tools In oralce mapviewer documentation but cant ...
0
votes
1answer
62 views

How do I create a point, buffer it, and intersect with polygon geometry?

The sql below is intended to create a point from a know X,Y. It should then buffer the point with a known distance. Last, the sql should intersect the buffer with an underlying polygon layer and ...
3
votes
0answers
67 views

How to hide system tables of oracle in sde connection?

I connected to oracle 11g r2 with ArcGIS 10.2 using SDE connection. The connection is ok but in the connection i see system tables of APEX_030200 and other schemas. Same question is in the Geonet ...
0
votes
1answer
341 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 ...
2
votes
1answer
50 views

Select by attributes for Arabic fonts in SDE/ file geodatabases?

I have a layer with names of electrical substations in Arabic language. there is no any problem when searching any Field names in English language whether from the SDE of file goedatabase I got the ...
0
votes
0answers
33 views

pl sql: copy Feature class attributes to another Feature Class

I'm new to oracle spatial, and am Trying to copy data from from Arc FeatureClass to another. I have tried the following, but am getting a 'PLS-306: wrong number or types of arguments in call to ...
3
votes
1answer
115 views

How are orphan gsrvr.exe processes created?

I just inherited a server running SDE application server 10.1 against an Oracle 11g database. I'm finding that many connections are not getting properly dropped and stay on as Orphans. Eventually the ...
0
votes
0answers
61 views

GDAL/OGR C++: How to connect to SQL

Using GDAL 1.11 it is possible to execute SQL commands against a OGRDataSource: But how do I connect the OGRDataSource to a SQL Database? In my case an Oracle XE 11g. I suppose the OCI drivers have to ...
0
votes
0answers
69 views

error using st_point with stored procedure (works in sqldeveloper but not in java)

A simple procedure: create or replace PACKAGE BODY TEST_PACK AS procedure test as begin insert into table_evw(shape) values (sde.ST_GeomFromText('point ('|| -73.16 || ' ' || 6.78 || ')', 4686)); ...
0
votes
0answers
29 views

How to model multiple topology classes in one query with ArcGIS

We have a lot of geographic data with different geometry type in our application, which are persisted in the Oracle 11g database with ST_Geometry supported by Arcgis SDE 10. The features can be ...
1
vote
0answers
223 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 ...
0
votes
1answer
161 views

How to update extent via sql (st_geometry) from ArcGIS for Desktop?

how to update extent via sql (st_geometry) using arcgis 10.2 i've noticed that if one inserts a geometry, let's say a point, into a table via st_geometry, the corresponding table extent is not ...
1
vote
1answer
71 views

How do I insert a date string into the database as a date?

I'm using an InsertCursor to insert rows into a feature class. One of the fields in the source data may contain a NULL data value. The destination feature class requires a date - it is not nullable. ...
0
votes
0answers
35 views

How do I synchronize field properties with the database properties?

I have a feature class with a property that is out of sync with the database table. The field property is "Allow NULL values" and it's currently set to "No". Earlier today, before I was aware of this ...
1
vote
1answer
57 views

QGIS Web Client Raster not visible

I have loaded rasters from PostGIS and Oracle Spatial 11g with below script.Both layers are visible in QGIS Dekstop.My OWS settings are correct but the Oracle raster layers are not visible in ...
1
vote
1answer
85 views

Load Oracle Spatial Raster using PyQGIS

Able to connect to Oracle Spatial 11g and print tables with SDO_GEORASTER attribute both in QGIS python console and standalone application.I get below error when loading rasters from oracle Table. ...
2
votes
1answer
188 views

Load PostGIS or Oracle Spatial Raster Layer using PyQGIS

How do we load Rasters stored in PostgreSQL-PostGIS or Oracle Spatial 11g into QGIS using PyQGIS? I am able to load vector layers from Oracle 11g with below code. What changes are necessary to add ...
0
votes
0answers
170 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 ...
2
votes
1answer
1k 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 ...
6
votes
0answers
243 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 ...
5
votes
2answers
402 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
501 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
880 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
437 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
156 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
842 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 ...
5
votes
2answers
1k 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
55 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
55 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
154 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
261 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
985 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
102 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 ...
2
votes
1answer
687 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
313 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
636 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
1k 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
348 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 ...
3
votes
1answer
343 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
527 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
81 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 ...
2
votes
1answer
224 views

Table doesn't match base table schema in Geodatabase Versioning?

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 ...
4
votes
1answer
5k 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, ...