A commercial relational database management system.

learn more… | top users | synonyms

2
votes
0answers
34 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 ...
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 ...
2
votes
1answer
249 views

Installing ArcGIS 10.1 on Win7 64 bit

Just reformatted my PC with Win7 64bit to try and take advantage of 64-bit python processing. However I'm not sure what to do here: Our office runs ArcGIS 10.1, TOAD and SDE for Oracle. Toad ...
1
vote
0answers
50 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 ...
0
votes
0answers
26 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
2answers
196 views

st_multi equivalent in Oracle spatial / how to convert polygon to multipolygon?

is there an equivalent to the PostGIS ST_MULTI available in Oracle Spatial? or - How can I convert POLYGON to MULTIPOLYGON in Oracle spatial? Regards, D
0
votes
1answer
63 views

Connect between Oracle 64 bit 11g and Arcgis10.1

How can I Connect between Oracle 64 bit 11g and Arcgis10.1 ? Thanks
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 ...
4
votes
1answer
118 views

Should slow refresh rate be expected while viewing 1000 points out of 100 million using ArcSDE/Oracle?

Is it normal to experience very slow refresh rate in ArcMap with 1000 points shown out of 100 million using ArcSDE/Oracle? I’am testing a setup with ArcSDE/Oracle database to contain geographical ...
2
votes
1answer
257 views

How to get a list of features from Oracle via FME?

I have a table in Oracle containing only the names of other tables of varying feature types, which I'd like to process (i.e.export to csv). this task is to be scheduled via FME Server. the feature ...
0
votes
0answers
52 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
22 views

Oracle spatial routing engine on Jboss

Is it possible to run Oracle Spatial Routing Engine 11g on JBoss AS7?
1
vote
1answer
165 views

How to export and import ST_GEOMETRY from Oracle environment to another Oracle environment?

I have a geographic layer stored in an Oracle Geodatabase with ST_GEOMETRY type. I'd like to export that layer and its data into a SQL INSERT format in order to import it into another Oracle ...
2
votes
3answers
246 views

Fastest way to join points table to polygons tables in ORACLE

I have two tables in 11g oracle db, one with points geometry, one with polygons. Currently I need to enrich the points table daily with the name of the polygon (country) that the point is inside, but ...
3
votes
1answer
915 views

Build a website to track GPS signals [closed]

I need to build a solution that allows me to track cellphones/tablets and display on a visual map. I think there are two parts, one is understanding the general architecture. The other is more ...
3
votes
1answer
1k views

ArcGIS for Server 10.1, Registering a database data store fails with Underlying DBMS error

When I registered a database data store to ArcGIS Server in ArcCatalog, the following error occurs: The connection property set was missing a required property or the property value was ...
0
votes
0answers
565 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 ...
1
vote
3answers
259 views

Differences between SQL dialects in QGIS vs ArcView vs Oracle

I'm kinda new with SQL queries and there is something I don't get: A SQL query in QGIS is written differently than the same query in ArcView and will probably also be written differently if I want to ...
3
votes
1answer
809 views

How to correctly set up Oracle connection parameters?

Just testing out the new QGIS2 install here and trying to connect it to our huge SDE/Oracle spatial database. Im struggling with the connection parameters. Here is the connection properties to the ...
1
vote
1answer
269 views

Arcsde and Oracle on same machine but while creating a Enterprise Geodatabase giving TNS Error

I have Installed Arcgis Desktop 10.2 and Oracle 11G and Arcsde 10.2 and oracle Client When I am Creating a Enterprise Geodatabase it is giving me this error: ORA-12154: TNS:could not resolve the ...
2
votes
2answers
176 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 ...
0
votes
1answer
328 views

Test of ORACLE DB functions converting lat-long to utm and mgrs with real data known to be correct?

I have rewritten some Delphi function to ORACLE DB functions for converting from lat-long to utm and mgrs. Anyone care to validate the output with real data they know is correct? package ...
2
votes
2answers
304 views

Can QGIS use a non-spatial Oracle Database?

I'm building my first plugin in qgis, that needs to read some coordinates from an oracle database (not oracle spatial database) and create a shapefile with this points. I'm searching but only find to ...
1
vote
1answer
81 views

Error occured during Geodatabase compressing

When I am doing geodatabase administration in ArcSDE on an Oracle Database, the following error pops up when I run the compress tool ORA-00604: error occurred at recursive SQL level 1 ORA-01000: ...
3
votes
2answers
63 views

arcgis desktop selection layer

I have Desktop 10.1 that is accessing data from sde geodatabase. I select some features on the map, and try to do "Create layer from selected feature" but nothing happen, and no error message. the ...
2
votes
2answers
502 views

finding the correct transformation (from EPSG:31300 to EPSG:4326) or how to store two srid in one table

I have a very specific problem. I have data crossing two coordinate-systems, more specifically: the Netherlands and Belgium. Previously the data was stored in one table in Oracle, using the RD ...
3
votes
1answer
1k views

Oracle spatial SDO_RELATE: why better performance result from UNION ALL/INTERSECT combined individual specified mask

Initially I was trying to find out why it's so slow to do a spatial query with multiple SDO_REALTE in a single SELECT statement like this one: SELECT * FROM geom_table a WHERE ...
3
votes
1answer
2k views

ArcSDE 10.2: How to enable and create Geodatabase in Oracle without ArcGIS Desktop

Since there is no Post Installation Wizard anymore in ArcSDE 10.2 - how can i enable und create a geodatabase in oracle without ArcGIS Desktop? We have only an EDN description for ArcGIS Server/SDE, ...
0
votes
1answer
232 views

ArcGIS - Help Using Oracle Function in Definition Query - No ArcSDE

I have set up a Query Layer pointing at an Oracle table with a SDO.Geometry column, and that is working and behaving fine. However, when I am attempting to set up a definition query that calls a ...
1
vote
0answers
80 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 ...
0
votes
1answer
94 views

How to Avoid Object ID conflicts in Versioned geodatabase

We have just implemented a versioned Geodatabase and our schema has few feature classes and relationship classes. We do not Reconcile and Post to the parent ( Default) version, as we need some ...
1
vote
1answer
36 views

Where is DatabaseSupport directory in the ArcGIS client?

May I know where is this folder stated in the guide? DatabaseSupport directory in the ArcGIS client installation location and move it to a location on the Oracle server. ...
0
votes
2answers
173 views

oracle search against intersect of a region that covers the whole world doesnt find any records

I am new to Oracle Spatial, I am trying to implement a service that will take coordinates from a map, and search our database to find any geometries that intersect with that map view. I works fine for ...
0
votes
3answers
267 views

For a SDE FeatureClasses list all Roles that have been Granted any Privileges on it, and which Privileges each Role have on it

I have searched through the ArcObjects 10 SDK API and googled, but havnt been able to find what I am looking for, so thats the reason for me posting this question. Q: How can I for a SDE ...
1
vote
1answer
176 views

SDE FeatureClass Granting and Revoking Privilege with ArcObjects

Q: How can I with ArcObjects GRANT or REVOKE Privileges like SELECT, UPDATE on SDE FeatureClasses to/from Roles? The equivalent in normal Oracle would be something like this: GRANT SELECT ON ...
0
votes
0answers
49 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". ...
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
156 views

MapInfo/PlanWeb and Oracle to ArcGIS/GeoCortex Essentials and Oracle [closed]

As an organisation we currently use MapInfo desktop GIS (120 users) and PlanWeb intranet GIS (about 1000 users), both products of Pitney Bowes. We have about 15 core desktop GIS users who edit spatial ...
1
vote
0answers
107 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 ...
3
votes
0answers
126 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...
1
vote
0answers
190 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 ...
3
votes
1answer
233 views

How can I validate a table name on SDE with Oracle backend?

Second title: "Is arcpy.ValidateTableName broken on Oracle?" I have an Oracle SDE database 9.3.1 (service connection). My arcGIS client tools are version 10.0 SP5). I have some names of feature ...
3
votes
4answers
696 views

converting oracle geometry to postgis with 3d data (wkt?)

I am converting Oracle spatial database to postgis. Most of of the spatial data is 2.5d. Meaning we have a Z-coordinate which indicates the depth/height of the element compared to soil level. Getting ...
1
vote
4answers
818 views

finding the definition of missing srid in postgis

I am converting a spatial Oracle database to POSTGIS, and one of the problems I encounter is that we use SRID in Oracle that do not exist in POSTGIS. I am talking about the following SRID: 90112 : ...
4
votes
2answers
273 views

Huge x,y,z dataset into oracle, possible?

I have 200 .xyz files containing 1500000 points each. Is this possible to import this dataset to oracle? It makes a total of 300.000.000 points!!! Background is I want to improve a FME script that ...
3
votes
1answer
662 views

Arcpy does not execute “CopyFeatures_Management” to write a featureclass to an ArcSDE database

I have some problems with my Python script. The script gets an JSON with different information about images. The information includes general information about images and also the gps position of ...
6
votes
2answers
755 views

GIS Database Migration Project (Oracle to ArcGIS)

I have been tasked with converting an Oracle Database into an ESRI file geodatabase. The data represents a gas network. The client's Oracle database has over 400 tables, 120 of which are spatial. ...
1
vote
0answers
251 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
2k views

How to manage user privilege on layers to Arcgis 10 Desktop?

Problem: I am a Computer Analyst on a town hall. Here we have the sector A and B. Both work in ArcGIS 10 Desktop. The sector A has granted to access/edit everything. The sector A has all the ...
1
vote
1answer
229 views

Using Query Layers with ArcGIS Server 10.0 for Java on Linux

I have an ArcGIS Server 10.0 for Java running under Red Hat Linux. I would like to be able to publish a Map Document that I have created which has a working Query Layer connecting to Oracle 11g. In ...