A commercial relational database management system.

learn more… | top users | synonyms

3
votes
1answer
270 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 ...
3
votes
1answer
254 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 ...
2
votes
1answer
115 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
1answer
32 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?
1
vote
1answer
29 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") ...
1
vote
1answer
28 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
1answer
61 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
1answer
52 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
1answer
47 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 ...
0
votes
1answer
65 views

Web Editing Versioned Enterprise GDB

I would like to implement a web editing environment where edits are posted to a version of a database (delta tables) not too default. The idea behind this is so that any edits made through a web app ...
0
votes
1answer
225 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 ...
0
votes
1answer
86 views

how to see a base map created by map builder in database?

I am new in oracle, I tried to create a style, then different themes and then a base map. I saved all my work, but I can't see the base map in the database. Did I miss something? The interesting ...
3
votes
0answers
156 views

Does QGIS Server support QGIS project with Oracle layers?

QGIS recently got native Oracle support. I was wondering if QGIS Server supports generating WMS and WFS from a QGIS project with Oracle Spatial layers. I just tested this but I did not succeed...
3
votes
0answers
639 views

oracle 10 connection on arcgis 10, windows 7

I have problem odbc connection on arcgis 10, oracle 10 and windows 7. odbc connection on windows, running well. but when arcgis conection via arcatalog, appear error "Test connection error because of ...
3
votes
0answers
189 views

ArcSDE Database Refactoring Tools?

We are using liquibase as evolutionary DB change management tool in our applications, it works great when we use it in "common" database schemas. But we also work with GIS applications using esri ...
2
votes
0answers
16 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 ...
2
votes
0answers
55 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 ...
2
votes
0answers
149 views

How to insert a large feature using C# and ST_GEOMETRY in Oracle

I am using the st_polyfromtext command to insert features into an Oracle database like this: INSERT INTO polygon_test VALUES ( sde.st_polyfromtext ('polygon ((10.01 20.03, 10.52 40.11, 30.29 41.56, ...
2
votes
0answers
256 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 ...
2
votes
0answers
39 views

Multiple Cursors

Below is the sql statement which I have explained below. Declare Cursor c1 is select store_number ,0 as total_area,0 as BG_ID ,0 as store_geom from table1 where CLIENT_ID= 1 and ORG_ID ...
2
votes
0answers
36 views

My view in Oracle when displayed in ArcMap/ArcCatalog values are being dropped to 0

I created a view in an Oracle Database in order to match formatting of a new database/table I am going to be migrating the data to. The problem is when I look at my view in Oracle I see the correct ...
1
vote
0answers
21 views

QGIS - 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 ...
1
vote
0answers
47 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
0answers
52 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
0answers
47 views

Insert SDO_GEOMETRY in cx_oracle

I have many polygons to insert. This code is ready to use. geom_str = ...
1
vote
0answers
65 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 ...
1
vote
0answers
53 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 ...
1
vote
0answers
45 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 ...
1
vote
0answers
75 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 ...
1
vote
0answers
468 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 ...
1
vote
0answers
65 views

Is there a way to prevent losing metadata when generating a spatial view in ArcSDE 10.1?

When generating a spatial view in ArcSDE using a script, any previous metadata is dropped when the old view is dropped. Thus, any edits to metadata on the view, are lost. Is there a way to keep the ...
1
vote
0answers
119 views

Oracle spatial. Cannot load data

Have just installed QGIS 1.9 with Oracle spatial abilities. We maintain geodata in an Oracle 9.2. spatial database. I get connected to the database but I can not load the data. The table shows up ...
1
vote
0answers
227 views

Oracle Spatial support QGIS 1.9-0-Master (Ubuntu)

I just installed QGIS 1.9.0-Master (Build 480) on a Ubuntu virtual machine. I am running/compiled against GDAL/OGR 1.9.2. My question is why I cannot add Oracle Spatial Layers as I am able to do ...
1
vote
0answers
74 views

sdequery.exe: When using functions as column names (-C parameter), how do you escape the comma for functions with parameters?

Using sdequery, I'm specifically trying to return sys_context('USERENV', 'SESSIONID'). user and sysdate work fine. Functions with single parameters work fine. But as soon as I use a function with ...
1
vote
0answers
151 views

Can I get the metadata about the themes in Oracle MapViewer?

I am trying to use the MapViewer xml api to generate a dynamic theme (for generic highlighting support), but don't want to expose table names and such to users, I would like then to communicate in ...
0
votes
0answers
21 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
0answers
44 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
0answers
101 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
0answers
58 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
0answers
28 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 ...
0
votes
0answers
68 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
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
0answers
89 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 ...
0
votes
0answers
46 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. ...
0
votes
0answers
143 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 ...
0
votes
0answers
169 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: ...
0
votes
0answers
31 views

Formula to know if LINE intersects with MBR

I have a table with four columns: SRC_X, SRC_Y, DST_X, DST_Y. (SRC_X,SRCY) have position of the start point of a LINE, (DST_X, DST_Y) have position of the end POINT of a LINE. I know there are ...
0
votes
0answers
956 views

Arcgis desktop connection to oracle

I am trying to create a database connection from ArcGIS desktop 10.1 to SDE Geodatabase on Oracle server with direct connection using Oracle easy connect syntax So, from ArcCatalog I use "Add database ...
0
votes
0answers
54 views

Geometry type invalid occurs while trying to view data from oracle to arcmap connection

I have been trying to connect oracle databse in to arcmap 10.1. It got connected but while trying to add feature type ( route network file) to the map it says "Coodinate system identifier is invalid". ...
0
votes
0answers
367 views

Publishing Oracle View in Geoserver Error

I am getting following error while publishing layer in geoserver: org.apache.wicket.WicketRuntimeException: Failed to add pluggable layer configuration panels at ...