A commercial relational database management system.

learn more… | top users | synonyms

0
votes
0answers
9 views

How do I find underlying tables used in connectivity?

First let me start by saying I am pretty much an ESRI neophyte. My experience is more with postgis and postgreSQL. I'm working on a project where we are trying to access the underlying connection ...
0
votes
0answers
21 views

Using FEAT_NUM Instead of FID as a Unique Identifier

In GIS data which entity would be the definitive Global Unique Identifier ? The FID which is a system generated unique number that once deleted will never be generated or a FEAT_NUM which is ...
0
votes
1answer
29 views

Oracle Procedure Call From ArcToolbox Script - Error processing call -

Background: I have an Oracle package with procedures to randomize and reset passwords for our SDE/GIS schemas. These procedures work perfectly via SQL Plus command line commands. My package looks ...
0
votes
1answer
49 views

Create a geoserver SQL view from Oracle SQL using a lat and lng column

I have a table in a Oracle SQL database in which I have a polygon geometry and two more columns of latitude and longitude. What I need is to show the points of lat and lng in a layer in geoserver. I ...
1
vote
0answers
17 views

deleting lines with smaller length and overlapping oracle spatial

I need to identifying polylines which are overlapping with each other and deleting them which is smaller in length in Oracle Spatial.
0
votes
0answers
28 views

Error when trying to open Oracle Spatial view in MapInfo 11.5

I have a Oracle Spatial table defined as follow: CREATE TABLE foo ( id NUMBER(9) PRIMARY KEY, sdo SDO_GEOMETRY NOT NULL ); And a view defined like this: ...
0
votes
2answers
56 views

ArcGIS 10.2 Query layer ID field using double / floating field?

I am using ArcGIS for Desktop 10.2. Am I correct in understanding that ArcGIS will only let you select an integer or text fields as the "key" ID when adding a query layer? Our Oracle enterprise ...
0
votes
0answers
41 views

Add and edit Oracle Spatial Layer in QGIS

When I connect oracle layer are not enabled me all editing options. I can create and delete but not update. It is an issue of users? permissions or privileges? metadata? All works OK in ...
0
votes
1answer
29 views

Refresh Database Connection in ArcCatalog

I have created a feature class in an Oracle 11g database connection with ArcCatalog 10.2 (without ArcSDE) and I can see the table in the database with Sql Developer without problems. But, if I drop ...
0
votes
1answer
32 views

Arc 10.2.2 crashes when adding query layer?

I'm trying to add a query layer from an Oracle database into a blank 10.2.2. map. I enter the query, validate, finish, and the software thinks for a second and then just winks out. No error ...
1
vote
1answer
35 views

Postgis/SpatiaLite SQL query to connect MySQL, Access or Oracle database

In SpatiaLite or Postgis, how can one create a SQL query to read a table from a MySql or Oracle database? I don't know **the correct SQL syntax to connect to a table in a MySql or Oracle database ...
1
vote
0answers
15 views

Accessing ORACLE table from QGIS gives TNS-12545 error?

I have to access one ORACLE tab from QGIS but it does not work. From Instantclient_12_1 the connection and parameters are ok, while from QGIS we always get TNS-12545 error. ORACLE_HOME and TNS_ADMIN ...
0
votes
0answers
19 views

View With SDO_GEOM Function for ArcMap

I have a table of boundaries(polygons) which need to be served up through ArcGIS Server with their centroids(points). I'm using Oracle spatial and thought the most efficient way of doing this was to ...
0
votes
0answers
35 views

Using ArcPy Insert Cursor with NEXTVAL of Oracle sequence?

I have the need to be able to set a value of a gdb table to the NEXTVAL of an Oracle sequence. I have to be able to do this through an ArcPy function that will also handle setting the ArcPy OBJECTID ...
0
votes
0answers
12 views

UNique ID Field for Oracle versioned GDB

We had a successful trigger through ArcFM, but we have abandoned their datamodel/product. We have a successful trigger when new features are added in a versioned edit session, BUT it does not work for ...
1
vote
0answers
84 views

QGIS DB Manager Import layer/file Oracle not working - Error 8 Loading of the layer failed

QGIS 2.12.0 - DB Manager 0.1.20 - Windows 7 - Oracle 11g 11.2.0.3.0 Import vector layer Shape file as well as a layer (vector) and with every possible combinations of settings, the results are the ...
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. ...
2
votes
2answers
71 views

Provide credentials for Oracle database when opening MXD file?

I need to open a MXD file from a Python toolbox (so that I can automatically export it to a PDF). The file contains a connection to an Oracle 11g database, and I need to somehow provide the ...
2
votes
1answer
71 views

Why does pyQGIS QgsVectorLayer().isValid() return FALSE with Oracle views?

This works perfectly fine with an Oracle TABLE but not with a VIEW. Why? uri = QgsDataSourceURI() uri.setConnection(host, port, db, username, pw) uri.setWkbType(QGis.WKBPolygon) ...
4
votes
0answers
105 views

Creating materialized view from ArcSDE layer

In the past I've used materialized views in Oracle to replicate non-spatial data from one database to another. I'd like to do the same thing with an ArcSDE feature class, but I'm wondering how that ...
3
votes
1answer
319 views

Update a table with values from coordinates on GEOMETRY in Oracle

I have 2 columns in a table that represent the X and Y coordinates. The values in those columns don't match the actual coordinates and I want to update them with the coordinates values that are ...
1
vote
1answer
56 views

How to set a specific ArcSDE version for tabular reporting?

I have created a multiversioned view in Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production. I can access a specific version using a SQL script in SQL Developer. However, using ...
2
votes
2answers
62 views

Is it possible to lock records or attributes indefintely if a field is populated?

I am creating a c# ArcGIS addin where I have a feature class stored in Oracle, when a feature is created some of the fields within the table will be populated. If field X is populated, then certain ...
0
votes
1answer
139 views

How to Query Oracle Geometry Data Type

How to I Query or find the type of geometry data type a given Oracle Database is using in SQL Developer (i.e. SDO_Geometry, ST_Geometry, etc)? I thought I could just descibe a feature class within the ...
1
vote
0answers
19 views

Regarding QGIS Connectivity To Oracle

I installed QGIS long term release today first 64 bit and second 32 bit. My problem is that SQL Developer for Oracle a non QGIS product does connect to Oracle and when I use the same credentials in ...
1
vote
1answer
93 views

Geoserver 2.7 - 'Bounding Box & Lat-Long Data' fetching problem from Oracle Locator database

I have installed Geoserver 2.7 & connected my Oracle (Locator) database with available 'gt-jdbc-oracle-13.2.jar' extension. During layer publishing containing fields like 'Geometry', it failed to ...
0
votes
0answers
25 views

ORACLE Metadata Table used by QGIS?

When connecting to ORACLE Spatial with QGIS, QGIS Needs a metadata table about all available Geomtry columns in the database. If not provided, QGIS scans all tables with geometry columns wich can ...
0
votes
1answer
510 views

Error connecting to SDE 10.3.1 on Oracle 12c from 10.1 client

We are currently planning an server migration. We have our current server on SDE 10.1 on Oracle 11 Currently our editors are on ArcGIS 10.1 with Oracle client 11.2 Our new server is setup and ready ...
0
votes
1answer
109 views

Get WKT from polygon centroid

I have an Oracle Spatial table (in 12c) with a polygon geometry type. I added a text column to the table that I would like to populate with the well-known text of the polygon's centroid. In concept ...
0
votes
0answers
20 views

ArcGIS 10.2 Oracle gdb got minus one from a read call

This is strange. Every certain amount of time (2 to 3 weeks) the gdb presents this problem. I've checked every possible line of code in a web app that consumes the layers stored there but do not see ...
0
votes
0answers
82 views

SQL query on field in Oracle does not return the same values that are seen in ArcMap/ArcCatalog

This is a very bizarre issue and I am at a loss as to why this is happening. A user running queries in SQL Developer brought this to our attention, and when we tried it we ran into the same problem: ...
0
votes
2answers
30 views

different calculation results

I spend a comparison of functions of spatial analysis and Oraсle postgresql. There are two tables with the same coordinate system - tech_bridge. oracle query select ...
0
votes
0answers
98 views

result map service in geoprocessing

I have created python script tool to select feature based on attribute and it works fine in arcgis desktop. I have published a geoprocessing service using above python script tool without any error. ...
3
votes
2answers
123 views

Switch between test and production database in ArcMap?

I have two Oracle 11g databases, one for testing (tst.world) and one for production (prd.world). Except when I am trying out new things, they have exactly the same table structure. In ArcCatalog I ...
1
vote
1answer
65 views

Where are Object class extension GUIDs stored in Oracle?

Where are the GUIDs for object class and workspace extensions stored in SDE for Oracle? I've looked through GDB.ITEMS but can't seem to find it. I think SQL Server stores it in an .xml column but I ...
1
vote
2answers
108 views

AddIndex_Management throws maximum open cursors exceeded

The following script is run to create indexes across all the feature classes within a particular dataset: import arcpy import os.path def listFcsInGDB(): for fds in ...
1
vote
2answers
429 views

How to programmatically import a Shapefile into Oracle DB using Java?

What's the best approach to import a user uploaded shapefile into an Oracle DB? The dbf, shx and shp files of the Shapefile come in a ZIP Archive. Currently, we unzip programatically and then parse ...
0
votes
1answer
87 views

Geoserver: WMS layer is shifted at certain zoom scales in openlayers

We use geoserver to serve WMS tiles inside a openlayers environment. The weird thing I see is that, in our production environment, depending on the scale, data is shifted (translated) against the ...
1
vote
1answer
149 views

Upgrading from sde 9.2/oracle10g to sde 10.2/oracle11g

I have an old geodatabase created using Arcsde 9.2 on Oracle 10g. Now, I'm trying to update it to new system using ArcSDE 10.2 on Oracle 11g r2. Because SDE 9.2 schema and SDE 10.2 are not ...
0
votes
0answers
101 views

Establishing direct connection to ESRI geodatabase on Oracle hangs while not in debug mode

Recently I have been trying to establish direct connection to oracle geodatabase using Java API. The problem is, that when I execute the code, the connection works fine only in debug mode when I ...
2
votes
1answer
78 views

Why value relation doesn't work when I delete and connect reference layer?

I'm trying to connect reference table (domain) with data(text) to my vector layer (id's) using value relation. I have database in Oracle connected. It works fine, but when I delete the reference layer ...
1
vote
0answers
86 views

Oracle add layer and Oracle Connection icons are missing

I have recently installed QGIS 2.8 and Oracle 11.2 Client on Linux Red Hat 7. Everything was fine, I am able to access Oracle database, as well as running QGIS. Unlike QGIS 2.8 from WIndows, Linux ...
0
votes
2answers
82 views

Monitor Traffic Between ArcGIS Server and Oracle DB

So, my dba informed me yesterday that ArcGIS Server made 40+ million requests to Oracle in a 20 minute period. That would be approx. 35k requests per second. I started laughing, and said we have the ...
1
vote
1answer
86 views

ArcSDE - spatial index grid size for empty table

I'm trying to write the SQL to create a feature class and spatial index in an Oracle SDE geodatabase using ST_Geometry. This is how I'm making the table: CREATE TABLE STREETS (ID NUMBER(11) NOT NULL ...
1
vote
0answers
87 views

How to pull data from multiple databases via Qt .ui form?

Using a single .ui form and wthin QGIS, can I show multiple records from another table that is associated with a single polygon? Table 1 contains planning applications ref Table 2 contains multiple ...
1
vote
1answer
103 views

Taking a long time to load tables from oracle to QGIS

My workplace has an oracle database with a very large number of spatial tables. Therefore, it takes a long time to load the oracle connection in QGIS. Does anyone know how this could be speed up?
0
votes
0answers
33 views

Why does WPS on Geoserver return unknown objects?

I am a beginner in GIS, more specifically Geoserver used with ESRI ArcGis, and here is my problem: When I run a gs:Clip WPS on a layer with points, some of the objects it gets from the oracle ...
0
votes
1answer
71 views

MapServer with Oracle 12

Atm. I'm running MapServer on Windows (with the msplugin_oracle.dll plugin) to create some WMS layers from SDO geometry stored in Oracle 11 database. I take the binaries from this very nice site. The ...
0
votes
0answers
166 views

Using St_geometry in oracle 11g

We are using ST_Geometry for Oracle 11g at the moment. And we need to query features (points,lines,polygons in a view) inside a given extent(either a circle or a polygon or a rectangle), and we use ...
0
votes
1answer
169 views

Geomedia Smart Client features, Oracle database

We have database schema imported in Oracle, but when we want to import it into Geomedia Smart Client (GMSC) certain tables are not visible in GMSC. On the other hand, VIEW created from these tables ...