A commercial relational database management system.

learn more… | top users | synonyms

0
votes
0answers
8 views

Auditing a Table's Changes Using Oracle and SQL Developer [on hold]

I need to create a table that audits the changes to a table which only has 2 columns (name and system) I need to keep track of transaction date, user performing the transaction, transaction type, ...
3
votes
1answer
243 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
0answers
35 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 ...
3
votes
1answer
252 views

How to clip a Oracle query layer directly in a Python script?

I have a query layer directly running from ORACLE database in a MXD. I want to clip this layer with a layer being created in another MXD in a Python based tool. My question is to do this clip ...
0
votes
1answer
46 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 ...
4
votes
2answers
661 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 ...
1
vote
1answer
25 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
18 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
16 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
34 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 ...
-1
votes
1answer
28 views

ArcObjects / Oracle12c / EZCONNECT

i am having some trouble connecting to Oracle12c via ArcObjects and EZCONNECT. Results so far: • Can connect via ArcCatalog 10.2.2 using an *.sde file. (EZCONNECT) • Can connect via ...
0
votes
0answers
61 views

Problems with direct connection to ESRI Oracle db for 9.3.1?

I am trying to create a direct connection to ESRI Oracle database for version 9.3.1. When I try to connect I get this error: org.geotools.arcsde.ArcSdeException: Can't create connection to none for ...
5
votes
7answers
5k views

Troubleshoot editing features in feature dataset with ArcMap / ArcSDE Oracle

I am having trouble editing a feature class that is in a feature dataset. We have added just the single feature class as a layer in ArcMap and are using the "Start Editing" function on the Editing ...
0
votes
1answer
197 views

Importing recent NAVTEQ/HERE RDF Data into Postgres/Postgis

I am trying to import a recent version of navteq data into a postgres DBMS. I have downloaded the 2014Q2 version of the data from https://here.flexnetoperations.com as well as ...
3
votes
2answers
627 views

Convert non-spatial Oracle table to spatial Oracle table in a different database

I'm trying to use ogr2ogr to convert data from a non-spatial table (has X & Y values) in an Oracle database (1) to a spatial format in a different Oracle database (2). This will be scheduled to ...
0
votes
1answer
23 views

How to set encoding when using ogr2ogr to export from oracle db to mapinfo table?

I am trying to automate the export of spatial data from a oracle database to mapinfo .tab files. Using this thread I made my script. However I can't see how to set the encoding right. My data have ...
0
votes
0answers
54 views

Accessing Versioned data using database link

I have geodatabase on one Oracle server. The data is versioned. I am trying to access the versioned data from another Oracle server using a database link. While accessing the a feature class named ...
0
votes
2answers
331 views

How to plot lat/long stored as text in Oracle DB using report builder/SSRS r2

We use an Oracle 10g database. However we write reports using SSRS or report builder, using the Oracle connection type to the datbase. In oracle we have 2 text fields, one for lat and one for long. ...
1
vote
0answers
37 views

FME Writing metadata to ArcGIS Online

I am trying to figure out how to write metadata to ArcGIS Online Feature Service from ORACLE SDE and how to update the existing Feature Service metadata, using FME or other tools. I am able to read ...
1
vote
2answers
74 views

GeoServer- Reload feature type doesn't work

I have Oracle database and I had created layer in GeoServer. It had worked good, but when I recreated database with different table structure (some columns dropped, some new added), I've got a ...
1
vote
1answer
262 views

where is the sequence in Oracle associated with the Objectid field in ArcGIS, and how to manage it?

I am working in ArcGIS 10.1 with non-spatial Oracle tables. These tables have a field named 'objectid' because were created originally for inserting/updating records by using ArcGIS instead, not ...
1
vote
0answers
33 views

Insert SDO_GEOMETRY in cx_oracle

I have many polygons to insert. This code is ready to use. geom_str = ...
2
votes
1answer
362 views

How can I use Oracle views with Geoserver and WFS-T?

What goes on when Geoserver handles updates to my table using WFS-T? I have a table AREA ( ID NUMBER(10) NOT NULL PRIMARY KEY, SOME_OTHER_ID NUMBER(10) NOT NULL FOREIGN KEY REFERENCES FOO(ID), ...
1
vote
1answer
49 views

Is it possible to get column names from an ArcSDESQLExecute SELECT execution

I am running ArcGIS 10.0 desktop and querying an Oracle 11g database and writing the results of a SELECT statement out to a CSV file. Everything works great; however, I would love to find a way to ...
2
votes
0answers
44 views

Different SRID problem

Hi here is my problem, I have two geodatabases and i import a number(large) of tables from one to another by using arccatolog(ArcGIS 10.2). However the tables and indexes created on them are imported ...
0
votes
2answers
76 views

Privileges for Oracle users created using the ArcGIS Create Database User tool

I've created an enterprise geodatabase on Oracle. I can connect to it from ArcCatalog and from SQL Developer using the SDE user. I've created a new user named GFPTest using the Create Database User ...
0
votes
1answer
46 views

Oracle Error 00936 in ArcMap

I am using ArcMap 10.2 and have connected to my Oracle database, and can see the tables in Catalog. However, when I try to add a layer I get "Could not add the specified data object to the map. ...
0
votes
0answers
27 views

Password Caching in ArcMap using Oracle accounts

The issue I'm looking for help with is that we have several Oracle accounts through which we host data. For example we have ACCOUNT@ORAC and ACCOUNT1@ORAC (these are made up names as I don't to ...
2
votes
1answer
78 views

Database connection times - PostGreSQL vs Oracle (ArcSDE)

I have 2 SDE instances. Both have the same amount of data (2000 datasets both raster and vector). One is PostGreSQL 9.2 with ArcSDE 10.2.1 One is Oracle 11g with ArcSDE 10.2.1 So basically the ...
0
votes
0answers
51 views

ESRI ST_Geometry struct parse in java

I am trying to read and parse the ESRI ST_Geometry which is an oracle user defined type in java manually, and I follow this instructions, and it said that: .... Points: Contains the byte stream of ...
0
votes
2answers
101 views

Does hibernate spatial support st_geometry created by ArcSDE?

We are using ArcSDE 10.0 to export data to the Oracle database, and the spatial property are saved using the SDE.st_geometry format. Now in our J2EE application we tried to manage these data by ...
0
votes
1answer
29 views

How to troubleshoot “RuntimeError: The field is not nullable [Column_Name]”?

I have a python (arcpy) script that extracts data from a database table, processes it, and inserts into a feature class. It works in my development environment but not in production. I recently ...
0
votes
1answer
36 views

How to identify Unposted/Outstanding (A&D) edits of a version in Enterprise SDE Database using SQL interface?

I am working on ArcSDE10.2.2 Oracle11G(11.2.0.4) enterprise geodatabase with user base 600+ and 2000 versions( Created from DEFAULT). For effective GDB compression and optimized performance delta ...
2
votes
1answer
157 views

Strange ArcSDE error inserting null into state_locks?

I'm working with a heavily customized version of ArcMap 9.3.1. It's heavily customized, but it mostly uses class extensions and special validations. Environment: ArcSDE installed in: linux, ...
1
vote
0answers
59 views

Which version of the Oracle Client do i need to get Oracle support in QGIS 2.6.1?

I have just installed QGIS 2.6.1 and wish to connect to our Oracle Spatial 11g Database. Am I correct in thinking I will need the Oracle Client installed on my machine for this to work? If so which ...
0
votes
2answers
114 views

How to read Oracle data with PyQGIS? (“identifier is not long” error)

Do you have any idea how load Oracle spatial data to QGIS with using the PyQGIS? Is it possible? I try: uri = QgsDataSourceURI() uri.setConnection("*host*", "1521", "*database*", "*username*", ...
1
vote
1answer
28 views

oracle VectorLayer without geometry - How to get attributes?

I have a prolem to iterating over a oracle VectorLayer without geometry in QGIS 2.6. self.uri = QgsDataSourceURI() self.uri.setConnection("localhost", "port", "xe", "name", "password") ...
0
votes
0answers
15 views

Can Framme Data be accepted by ArcFM in RMAN backup format?

I am aware that Framme data can be converted into ArcFM; however, can it be accepted in RMAN backup format?
0
votes
1answer
113 views

Connecting to Oracle database on a network in python

There is lots of information out there on how to do this, unfortunately, it all looks like Greek to me. I need a connection to a DB so I can add and use tables and featureclasses contained within ...
3
votes
3answers
685 views

How to connect QGIS to an Oracle DB (SDE)?

I want to access an Oracle Database (with SDE) from Qgis 2.4. I have tried many different options from within the window Create a new Oracle Connection but I always get an error message (ORA-12514: ...
0
votes
1answer
189 views

Spatial query without spatial database module?

I have the following scenario: Oracle database without the spatial module. Application in J2EE with the following architecture: -- Entity -- Persistence (DAO / JPA + JDBC) -- Business (BC) -- Vision ...
0
votes
1answer
119 views

QGIS and Oracle Spatial database - rule based system in future version?

I (a geographer not to familiar with IT stuff) want to start a pilot with QGIS at a municipality I work for. We store our data in Oracle databases. When trying to open these databases (QGIS 2.2) using ...
2
votes
1answer
103 views

How to clear spatial reference identifier?

I created a table in oracle with a sde.st_geometry column. I followed the instructions of ArcGIS help to register the table into geodatabase. My table creation statement is: create table ...
2
votes
2answers
250 views

Call ArcGIS Repair Geometry Function from Oracle 11.2

Could anyone please point me to the right direction on how to call an ArcGIS Function (i.e. Repair Geometry) from PL/SQL? All information I found so far concerns the other way round. This is needed ...
1
vote
1answer
497 views

Bulk insert with Python and cx_Oracle into st_geometry enabled table

I'm trying to make a bulk insert of a CSV file with Python and cx_Oracle into an st_geometry enabled table of an Oracle database with ArcSDE. I could do it with the method execute() of cx_Oracle but ...
1
vote
1answer
58 views

Associating 9.3 geodatabase domains to a SDE feature class' field in ArcCatalog 10.1 fails

I have succesfully created Domains into a 9.3 geodatabase based on Oracle (SDE) by using ArcCatalog (ArcGIS 10.1). Proof: If I open the table GDB_DOMAINS in Oracle the new domains are listed. ...
1
vote
1answer
52 views

Best way to store raster data with Java into Oracle spatial

I have a Java application that processes raster data. At the end of the process I plan to store the raster in oracle spatial. What is the best way to do this? I had a look at geotools but I did not ...
5
votes
3answers
365 views

Updates to ArcSDE via Oracle trigger

Is it possible and/or feasible for an Oracle trigger to periodically update ArcSDE via a REST geoprocessing service? Does anyone have any experience with such a thing? The reason for this is that I ...
0
votes
1answer
235 views

Creating a layer in arcmap by dragging a table from an OracleDB

I am working on a project for a client, they gave us some data from their oracleDB, and when I connect to it in arc map I can just drag and drop the tables from the catalog window into arcmap and they ...
0
votes
0answers
79 views

Delete user on ArcGIS server against Oracle backend

I have a problem, when we delete users, using the following command: drop user sdedata cascade; We get the this error: ORA-00604: error occurred at recursive sql level 1 ORA-21700: object ...