A commercial relational database management system.

learn more… | top users | synonyms

1
vote
1answer
19 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
13 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
14 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
31 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
41 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. These tables have the complex geometry column. On ...
-1
votes
1answer
25 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
55 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 ...
0
votes
1answer
19 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 ...
1
vote
0answers
34 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
70 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
0answers
31 views

Insert SDO_GEOMETRY in cx_oracle

I have many polygons to insert. This code is ready to use. geom_str = ...
2
votes
0answers
43 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
73 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 ...
1
vote
1answer
47 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 ...
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
26 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
76 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
45 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
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
35 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 ...
1
vote
0answers
57 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
97 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
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?
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
1answer
110 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 ...
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 ...
1
vote
1answer
478 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 ...
0
votes
0answers
76 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 ...
2
votes
1answer
110 views

Reordering Tables in ArcMap Layer List?

I'm trying to reorder the TABLES in my ArcMap layer list. I can't find a way to do it. I can reorder normal layers since they appear in the "List by Drawing Order" tab of the "Table of Contents". ...
1
vote
0answers
50 views

Migrate MS Access Data into Oracle DB

I was sent some old MS Access files that contained survey data and served as a "file geodatabase". I want to import these to my Oracle Database with it maintaining "geometric" sense and meaning. I ...
0
votes
0answers
42 views

Table To Table on Oracle table to File Geodatabase fails?

I recently upgraded to 10.2.2 and have found that some python scripts I used with table to table command no longer work. I am copying tables from an Oracle database to a file based geodatabase. ...
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
251 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
43 views

Geoserver Image Mosaic Plugin - Index Table - ORACLE

On my current project we are using a Geoserver ImageMosaic to display aerial photography for England. We are also working to enable the TIME attribute on the layer so that we can display historic ...
0
votes
0answers
127 views

Storing 3D Oracle sdo_geometry objects with a 2D SRID

I'm trying to understand the implications of storing 3-dimensional sdo_geometry values in Oracle when the geometry's SRID is a 2-dimensional system. The database I'm studying uses SRID 4326 (WGS84 ...
1
vote
1answer
26 views

Syntax to view permissions on Oracle table

I want to be able to see what permissions have been granted on a specific object in my Oracle geodatabase. What would my script look like? Thank you.
0
votes
0answers
150 views

Error selecting geometry from Oracle DB

I'm trying to select a geometry column as well-known text from a feature class in an Oracle 11g/ArcSDE 10.1 geodatabase. (This is in a Python script using pypyodbc as a driver). This is my SQL: ...
1
vote
1answer
170 views

How to create a shapefile or gml from a Oracle database using SDE.ST_Geometry?

I have a ORACLE database 10g(Oracle Database 10g Enterprise Edition Release 10.2.0.3.0) with a SDE.ST_Geometry field and i want to make a program in python so i can create several shapefiles based on ...
3
votes
3answers
673 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
91 views

Error configuring Oracle datastore in GeoServer

I want to configure an Oracle datastore in Geoserver so I copied gt2-oracle-spatial-2.3.1.jar and ojdbc14.jar into GeoServer webapp (in WEB-IF/lib folder); then I restarted and try to create new data ...
0
votes
1answer
30 views

MapServer - Not Rendering All Features With Complex DATA statement

I have run into a little problem when using MapServer to render complex data statements. To keep this post short and simple, I think the output of shp2img is the best place to start. When I use ...
1
vote
1answer
211 views

Can't select geometry from Oracle DB using SQL

I'm trying to select the geometry field from an ArcSDE feature class in an Oracle 11g database (inside of a Python script via PyODBC). This is my query: SELECT SHAPE FROM USR.FEAT_CLASS This is ...
1
vote
0answers
66 views

Using IRelationalOperator ArcObjects interface with feature classes stored in Oracle?

Could you give an example how you’d use the IRelationalOperator ArcObjects interface with features from different feature classes stored in oracle database? In my visual studio project I have an xml ...
2
votes
1answer
46 views

Incomplete Data - Missing line segments from Oracle data

I have setup GeoServer 2.5.2 on Windows. Everything was going smoothly until I actually had to display my geometry data from an Oracle Database Table. Some lines are rendered but some are not ...
0
votes
1answer
138 views

geoserver fails to start with jdbcconfig community module

I have installed the geoserver JDBC config community module, but now geoserver fails to start. I have set the properties to connect to an oracle database like this: #Default GeoServer JDBC config ...
1
vote
2answers
113 views

Query to find all lines connected to other

I have problem with one spatial (Oracle) query. Simplified overview of the problem is: I have two tables: CREATE TABLE thin_lines ( id NUMBER PRIMARY KEY, geom SDO_GEOMETRY), color ...
0
votes
1answer
73 views

GeoPortal - A database Reference has not been configured for connection Tag

I've followed the instructions on setting up to a tee. I am using Oracle as a database. My database structure has been setup. I receive the following error message when I try to search for anything: ...
3
votes
2answers
309 views

Importing Feature Class to Oracle SDE Geodatabase Simplifies Features

I recently imported a feature class from a File Geodatabase to an Oracle SDE Geodatabase. The features of the two feature classes now look drastically different despite not having any edits made. ...
2
votes
1answer
102 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 ...