A commercial relational database management system.

learn more… | top users | synonyms

4
votes
2answers
226 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
2answers
88 views

Add Oracle spatial view Layer

Is it possible to add an Oracle Spatial View on QGIS MAP? My view is registered on MDSYS metadata but, when I connect with Oracle DB, it is dissabled on the list. QGIS Desktop 2.2.0 Oracle Database ...
3
votes
1answer
57 views

ORA-28595: Extproc agent : Invalid DLL Path

I'm trying to create a table with spatial column in oracle and insert data into it. I'm using ArcSDE and Oracle. The version of Oracle is 11.2.0, the version of ArcSDE is 10.0. My create statement ...
3
votes
1answer
479 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 ...
3
votes
1answer
222 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
68 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 ...
2
votes
1answer
157 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
49 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 ...
1
vote
1answer
176 views

How to merge/union non contiguous polygons using Oracle Spatial functions

Is there any way of merging non contiguous polygons using the SDO_AGGR_UNION or a similar dissolve function? When i run the below query in oracle sql developer i managed to convert geometry type from ...
0
votes
1answer
11 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 ...
0
votes
1answer
28 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*", ...
0
votes
1answer
47 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
56 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 ...
0
votes
1answer
33 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 ...
0
votes
1answer
46 views

QGis and Geomedia via Oracle

When I use both QGis and Geomedia to digitize in the same layer I get some issues in my Oracle table. It looks like Geomedia save my point, lines and polygons as ARRAY, while QGis save it like POINT ...
0
votes
1answer
194 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. ...
0
votes
1answer
111 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
1answer
56 views

Connect between Oracle 64 bit 11g and Arcgis10.1

How can I Connect between Oracle 64 bit 11g and Arcgis10.1 ? Thanks
3
votes
0answers
157 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 ...
3
votes
0answers
118 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
174 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
36 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
33 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
34 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 ...
2
votes
0answers
556 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 ...
1
vote
0answers
70 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
47 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
78 views

ArcMap vertex problem for Z-value

I have an Oracle Spatial dataset with z-coords. I can edit the dataset in ArcMap however the z-values are always rounded to the nearest integer. Why does ArcMap round the z-values? Regards, Pieter ...
1
vote
0answers
103 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
181 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
222 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
0answers
62 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
139 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
20 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
0answers
26 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
28 views

Qgis Server, show Oracle Georaster dynamically

I have an Oracle Spatial database and I use rasters (SDO_GEORASTER). I can render some rasters on a web page with Qgis Server : when I render the maps on the webpage, it come from a qgis project ...
0
votes
0answers
14 views

applyEdits method and File on arcgis feature service

I would like to know if it's possible to upload a file through the applyEdits method on a feature service? I have an Oracle database with a parameter "DOCUMENT" of type BLOB. I would like to upload ...
0
votes
0answers
44 views

QGIS 2.2 - Oracle Spatial Layer - Offline editing - Not synchronizing

I am sarting with QGIS 2.2.0 (windows, 64b). For my project I imported some layers Oracle Spatial layers (Layer>add Oracle Spatial Layer). Then I convert the project offline as I can't always be ...
0
votes
0answers
58 views

QGIS browser connect to Oracle DB, while QGIS GUI doesn't … why?

I installed QGIS 2.0.1 on my Windows 7 platform. Using QGIS browser I successfully connect to an Oracle DB specifying into the connection dialog box the following information HOST = the machine IP ...
0
votes
0answers
30 views

SQL cursor issue

I am trying to create a new table using a cursor and a select statements. Declare Cursor c1 is select store_number from table1 where CLIENT_ID= 1 and ORG_ID = 1 ; Type C1_TAB_TYPE ...
0
votes
0answers
21 views

Multiple cursors in sql for SDO_DIFFERNCE

This is a follow up to a previous question I had regarding sdo_difference. Now in this case I am trying to use cursors so that I can do it for all records at once.In the below code I select a list ...
0
votes
0answers
35 views

NextBuffer operation takes a long time when there are no rows in a table

We're trying to get data from a table which contains no rows. The query runs fast, but the SDE gets stuck on NextBuffer command. Some code that we're using: IQueryName2 queryName2 = (IQueryName2)new ...
0
votes
0answers
50 views

How to get Geodatabase into Oracle database/ Tables

Simple question possibly. But how can I import a Geodatabase into a oracle database. I like to put data into tables but just wondering what is the best way or tools to use? Will it be through FME ...
0
votes
0answers
21 views

Oracle spatial routing engine on Jboss

Is it possible to run Oracle Spatial Routing Engine 11g on JBoss AS7?
0
votes
0answers
440 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
48 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
304 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 ...