Questions tagged [oracle-dbms]

Use for questions about Oracle DBMS that are not about its Spatial or Locator extensions

Filter by
Sorted by
Tagged with
0
votes
0answers
13 views

Editing EGDB data with Portal/Collector: Do error messages from the DB pop up in the app?

Oracle 18c; Portal/ArcGIS Server 10.7.1 I'm considering setting up Portal so that I can edit my on-premise EGDB data in the field using ArcGIS Collector. As part of this implementation, I would have ...
0
votes
0answers
10 views

Prevent users from deleting EGDB tables

Oracle 18c/10.7.1 geodatabase: My geodatabase has an owner/schema/user called OPERATIONS. Operations staff have a direct db connection in ArcMap/Catalog to the OPERATIONS owner. This connection is ...
1
vote
0answers
17 views

I need to remove Z dimension on spatial column (ST_GEOMETRY) with Esri on Oracle using the PL/SQL packages

I need to remove Z dimension on spatial column (ST_GEOMETRY) with Esri on Oracle using the PL/SQL packages I need to do the following, but using the ESRI PL/SQL packages on Oracle. I have used a ...
0
votes
0answers
23 views

Under what circumstances would the _DELETE trigger get called? (_EVW)

Oracle 18c/10.7.1 geodatabase: When an FC is registered as versioned (with option to move edits to base), several triggers get automatically created: V000001_DELETE V000001_INSERT V000001_UPDATE ...
2
votes
2answers
100 views

Prevent deletes in a versioned table at the database level

I have a table in an Oracle 18c/10.7.1 geodatabase. The table is versioned with the option to move edits to base. As far as I can tell, it's not possible to prevent ArcGIS Desktop users from deleting ...
2
votes
1answer
76 views

Calculate irregular polygon center-point that falls within the polygon boundary

I have an SDE.ST_GEOMETRY polygon FC in an Oracle 18c/10.7.1 geodatabase. I can calculate the X and Y of the polygon centroids using the SDE.ST_GEOMETRY ST_Centroid function: sde.st_x(sde....
0
votes
2answers
51 views

Creating a view in ArcCatalog - ORA-01722 [closed]

I'm creating a view in ArcCatalog 10.6 on an Oracle DB. Never created a view before but with some Googling, I've managed the SQL below. The view works but only partially. In ArcCatalog, preview shows ...
1
vote
1answer
292 views

How to find closest point on a line from a point in Oracle Spatial?

I want to find the nearest point on a line from a point in Oracle Spatial. I know how to do in SQL Server and PostgreSQL but could not find anything about Oracle. I have used MDSYS.sdo_nn to find the ...
1
vote
2answers
256 views

Converting SDE.ST_GEOMETRY polyline to SDO_GEOMETRY with SQL: Why are there so many nulls?

I have a SDE.ST_GEOMETRY polyline FC in an Oracle 18c/10.7.1 geodatabase. I want to convert the SDE.ST_GEOMETRY shape column to SDO_GEOMETRY using SQL. Reason: So that I can do linear referencing ...
0
votes
0answers
32 views

Getting SQL explain-plan for ArcGIS Map service

My organization has an ArcGIS map service that contains registered views from an Oracle 18c/10.7.1 geodatabse. I'm having some performance issues with the layers/views in the map service. I want to ...
1
vote
1answer
104 views

Use SDE.ST_GEOMETRY functions in a custom function

I have a dummy query where I generate an SDE.ST_GEOMETRY point: select shape as srid_test from ( select sde.st_geometry ('point (10.01 50.76)', 4326) as shape from ...
0
votes
0answers
40 views

Select list of tables and feature classes that have subtypes?

I have tables and feature classes in an Oracle 12c geodatabase (10.7.1). I would like to generate a list of tables and feature classes that have subtypes defined in them. Is there a way to do this ...
1
vote
1answer
89 views

How to filter date values using OGR 2.4.0?

I am trying to replicate a working Oracle SQL query into ogr2ogr, but having issues with a date field where clause. My query is: select BLOCK_STATUS_DATE, GEOMETRY from WHSE_FOREST_TENURE....
2
votes
1answer
251 views

Get midpoint of SDE.ST_GEOMETRY polylines?

I have a polyline SDE.ST_GEOMETRY feature class in an Oracle 12c geodatabase (10.7.1). I want to create a view on the feature class that has X and Y columns that contain the coordinates of the ...
0
votes
0answers
60 views

No Oracle Button in QGIS Data Source Manager on Linux

I'm using QGIS 3.10 on a system with Fedora 30 Linux. In the Data Source Manager is the button for Oracle-database-connections missing. An installation of the same QGIS-version on a Windows-Machine ...
1
vote
1answer
19 views

Extract subtype codes and descriptions in a view

I have an Oracle 10.7.1 geodatabase that has tables and feature classes with subtypes. How can I extract the codes and descriptions from the subtypes in a view?
0
votes
1answer
17 views

Converted timezone does not display properly in ArcMap

(Oracle 12c geodatabase) I have a view that converts a UTC timestamp to Eastern Time using the from_tz function: create or replace view test_vw as ( select cast(rownum as number(38,0)) as ...
1
vote
1answer
49 views

SDO_JOIN conversion to PostGIS

I make refactoring from Oracle to PostGIS and I found out that PostGIS doesn't support sdo_join. How should I correct the statement below? SELECT e.ID AS EDGE1_ID, u.NODE_ID AS ...
6
votes
1answer
147 views

ArcPy UpdateCursor auto pausing after every 1000 records

I have an update cursor running that updates a field based on a lookup table (Python dictionary). The cursor completes fine, but seems to pause and hold after each 1000 records - I have a test in it ...
0
votes
0answers
54 views

WHERE clause that's stored in a table: Use it to filter a layer?

I have a workorder management system (WMS). The WMS has functionality that allows users to save queries. The queries are saved in a Oracle database table called QUERY (in a CLAUSE column). An ...
0
votes
1answer
85 views

Selecting the SHAPE column in Toad

I've noticed that SQL clients select the SHAPE column from SDE.ST_GEOMETRY in different ways: select shape from roads Toad: SDE.ST_GEOMETRY(1,1,666666.0,4444444.5,666666.0,4444444.5,NULL,NULL,NULL,...
0
votes
0answers
105 views

ST_TRANSFORM SDE Oracle does not convert the geometry

I try to convert a geometry from 31370 to 3857. But it does not work. The coordinates stay in 31370. DB: Oracle 11 ArcSDE: 10.4.1 The code: select sde.st_srid(shape) ,sde.st_x(shape) as ...
0
votes
0answers
40 views

Select domain's last update date

I have tables in an Oracle 18c GDB that I integrate to a work order management system. I create views on the tables to translate the data. For example, I translate codes to domain descriptions. I ...
1
vote
2answers
75 views

Prevent row deletion in versioned tables using database privileges

I have versioned tables in an Oracle geodatabase (versioned with the option to move edits to base). I would like to prevent users from deleting rows from the tables when using ArcGIS Desktop. (With ...
1
vote
0answers
82 views

Connecting QGIS to Oracle?

I am using QGIS 3.8 MacOS. I know that prior releases of QGIS (2.x releases) did not include drivers to connect to Oracle databases, and one would need to compile QGIS themselves with the proper ...
2
votes
0answers
87 views

GeoServer and Oracle connection

I installed GeoServer on a server, put the Oracle extension in the same version. When I click store and then Oracle NG, I put the data of my connection and when I save, presents the error below: ...
1
vote
0answers
41 views

Updating spatial table in Oracle database with SQL query in PyQGIS?

I am trying to use the Python Console within QGIS 3.4 to update a spatial table in an Oracle database. The goal is to update all values in the field DTM_ELEV in the Oracle table with values from a ...
2
votes
1answer
61 views

Unable to establish Oracle enterprise connection using ArcMap

When I run the following command sqlplus user/mysecretpass@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=10.1.250.81)(Port=1521))(CONNECT_DATA=(SID=gisdb))) I am able to establish connection and result ...
0
votes
1answer
82 views

Convert Oracle data to polygons using R

I have a polygon file, taken from an Oracle database, that looks something like this: ID FMC_AREA_TYPE_NAME DESCRIPTION 1 162 HARBOUR Esbjerg 2 164 HARBOUR Thyborøn ...
0
votes
1answer
813 views

Connect ArcGIS 10.6 to Oracle 12c Enterprise Edition

I want to connect ArcGIS 10.6 to an Oracle 12c Enterprise Edition. However, I found different informations on the Esri websites on how to do so. I followed this website (http://desktop.arcgis.com/...
1
vote
0answers
86 views

Insert new features into Oracle DB using PyQGIS

I need to insert new objects into a specific layer that stored in Oracle database. Firstly I set a new QgsFeature(), then set geometry and attributes. Finally perform addFeatures() action. nodes_pnt =...
1
vote
2answers
518 views

Database support in GE Smallworld?

What database engine can be used for GE Smallworld? I have poor information but I read about Smallword proprietary VMDS. Is it possible to use Oracle or SQL Server?
0
votes
1answer
149 views

Using Google Encoded Polyline Algorithm Format with Oracle Database

Google's Encoded Polyline Algorithm Format is implemented in several GI tools. PostGIS e.g. has ST_AsEncodedPolyline and ST_LineFromEncodedPolyline functions. In contrast, Oracle Database has no ...
2
votes
1answer
50 views

How to hide certain views from ArcCatalog?

I have users that connect to an enterprise geodatabase via OS authentication. They use a couple of methods: An .SDE connection in ArcMap A ODBC connection for MS Office The users need to be able to ...
2
votes
1answer
307 views

Execute Oracle stored procedure from ArcSDESQLExecute

I'm attempting to execute an Oracle 12c stored procedure using ArcSDESQLExecute: import arcpy egdb_conn = arcpy.ArcSDESQLExecute(r"Database Connections\con1.sde") sql = '''execute update_sle (...
0
votes
1answer
112 views

Insert 1 row that has tens of thousands of geometry data on Oracle

I have a query to insert 6 geometry data like this DECLARE v_geom sdo_geometry; BEGIN v_geom := MDSYS.SDO_GEOMETRY(2003,4326,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(107....
2
votes
1answer
107 views

QGIS 3 imports DATE type colum in Oracle Database as QDate, losing hh:mm:ss

I am at the moment working on a lift for an QGIS 2 plugin to work with QGIS 3. The plugin specifies a QgsDataSourceUri and uses it in an QgsVectorLayer. In the specific table, laying in an Oracle ...
1
vote
0answers
257 views

How to Create 'Update Triggers' to Track Field Values Changes When Data is Versioned?

How can I create a trigger to capture when a field is changed from one value to another if my data is versioned? I am not able to run an UPDATE trigger and grab ':new' and ':old' values because with ...
0
votes
1answer
77 views

GeoServer 2.13.3 unable to delete from Oracle 11gR2 over WFS-T

I'm attempting to upgrade GeoServer 2.9.2 to 2.13.3. GeoServer uses the Oracle Data Store plugin (updated to gt-jdbc-oracle-19.3 as part of the upgrade). Oracle is 11gR2. One of the applications ...
0
votes
2answers
111 views

Clarification on Oracle sdo_gtype

I need some clarification on oracle sdo_gtype 4402. I understand that sdo_gtype is codded as DLTT. D: Dimension L : linear reference T T: TT identifies the geometry type. It's clear to me that first 4 ...
0
votes
0answers
128 views

Query Feature Class from Oracle table with no geometry column

Using ArcMap 10.4.1 I am trying to create a query layer from an Oracle table (Oracle info at bottom). The table has no geometry column, but has x and y coordinates as double and I am trying to create ...
2
votes
0answers
93 views

Versioning with Oracle Workspace Manager in QGIS?

I'm working with a workspace enabled oracle database. Through the database connection properties in QGIS meanwhile it is possible to set the workspace or version. So I can edit my spatial data in a ...
0
votes
2answers
424 views

Oracle DB tables extract with python

I have an Oracle database that I have been extracting the certain geometry tables into QGIS and then creating shapefile files for those tables. Does anyone have any tips or tricks to automatic the ...
0
votes
1answer
104 views

Update DB Geometry using GDAL

We are working with a geometry DB (Oracle) and use GDAL to download some data and apply changes to it. Supposing that we were applying the following workflow: DB -> GeoJSON -> modified_GeoJSON Is ...
1
vote
1answer
88 views

Detecting failure of Data Access Insert Cursor?

I have data that I have now determined is failing because the underlying Oracle table has a unique constraint that fails. When a duplicate row is inserted there are no exceptions thrown - no way ...
2
votes
0answers
55 views

Select events that represent the most recent work on roads

I have a question on Stack Overflow where I ask about Selecting events that represent the most recent work on roads. So far, I have been provided an answer that seems to work, although it is quite ...
1
vote
0answers
58 views

Editing Spatial View in ArcMap?

Can spatial views be edited via ArcMap and, if it is possible, then how do I do it? I do have my Enterprise Geodatabase on Oracle.
0
votes
1answer
659 views

GeoServer and Oracle 12c

In GeoServer (2.13.1) I'm trying to connect to Oracle DB 11g and 12c and connecting successfully both. But in 12c I couldn't see my tables and can't add layer. There isn't any error message or ...
0
votes
2answers
364 views

Oracle - find N neighbors (points) of a point within a radio

I have this table, there it goes a sample output to show that it is a point select SDO_UTIL.TO_WKTGEOMETRY(geo) from places where id=1 _______________________________________________________ POINT ...
2
votes
0answers
36 views

Multiple Layers into Indiviual Shapefiles QGIS

I have extracted about 20 different tables out of an Oracle DB into a project now I want to save each one as a shapefile. I know how to save an individual layer into a shapefile but is there a way to ...

1
2 3 4 5
7