Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

Questions tagged [oracle]

A commercial relational database management system.

Filter by
Sorted by
Tagged with
6
votes
1answer
129 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
35 views

WHERE clause that's stored in a table: Use 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
0answers
26 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 where Toad: SDE.ST_GEOMETRY(1,1,666666.0,4444444.5,666666.0,4444444.5,NULL,NULL,...
0
votes
0answers
23 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
25 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 prepare & translate the data for the integration. For example, I translate ...
1
vote
2answers
28 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 ...
0
votes
0answers
22 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
32 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: ...
0
votes
0answers
34 views

Is there a way to deploy Oracle Instant Client with an ArcGIS Add-In to access geodatabase objects?

I would like to open a feature class stored in an Oracle Enterprise geodatabase from an ArcGIS 10.4.1 Add-In without installing an Oracle Client on the end-user machine. Currently, I can use the ...
1
vote
0answers
18 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
49 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
0answers
73 views

SDO Oracle Table not recognized as Geometry in QGIS

I can connect to the Oracle Database with QGIS but spatial table/layers are not recognized as such. I have read the following in the QGIS documentation: Normally, an Oracle Spatial layer is ...
0
votes
1answer
44 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
0answers
78 views

Why does QGIS try to insert a known CRS into sdo_coord_ref_system?

When using "Import vector layer" in QGIS DB Manager (QGIS 3.6.0) to load a layer to an Oracle database (12.2.0.1.0) I get the following error: Error 2 Creation of data source "XXXXX"."MY_TABLE" ...
0
votes
1answer
332 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
47 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 =...
0
votes
1answer
273 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
0answers
22 views

What is the underlying algorithm of sdo_sam.spatial_clusters in Oracle?

Oracle has a "sdo_sam.spatial_clusters" function for spatial clustering. What is its underlying algorithm? Unfortunately the Oracle docs do not mention the algorithm or describe in which way the ...
0
votes
1answer
108 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
43 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 ...
0
votes
0answers
59 views

Speeding up Oracle Spatial intersection query and indexes

I have about 300 000 records (worksites) in a table (S) with id (id_s), start_date, end_date (and in some cases an authorisation date - AUTH_START). I have a second table containing the id of 500 of ...
1
vote
1answer
156 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
68 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
0answers
66 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
156 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
64 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
67 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
101 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 ...
1
vote
0answers
73 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
285 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
82 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 ...
0
votes
1answer
42 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
55 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
380 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
152 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 ...
1
vote
1answer
84 views

What is mapinfo precision on coordinates

I have some roads on Mapinfo and looks OK, all nodes seem connected at 0.01 m Zoom. If you try to export it to mid/mif you can see the same coordinates (-63.869036 11.039044)on all 3 lines. Line -63....
2
votes
0answers
33 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 ...
0
votes
1answer
419 views

What to do about QSqlDatabase: QOCI driver not loaded [closed]

QGIS - 3.0.1 I am trying to connect to the Oracle database. I am not an expert in QGIS, pyqgis at all. I took help of following code to connect to Oracle database. Connecting directly to an Oracle ...
0
votes
1answer
264 views

Oracle equivalent to postgis EPSG 4326 “geometry” type

We have polygons stored in Oracle SRID 8307 (geodetic datatype), but need to perform various operations on this layer in a 2d cartesian/non-geodetic system based on the geographic coordinates. I.e. ...
1
vote
0answers
16 views

What is Oracle/ArcSDE doing to my simple WKT Conversions?

I have no way to explain the output of the following: DECLARE splitGeom sde.ST_Geometry; stas CLOB; BEGIN SELECT sde.st_geomfromtext( 'POLYGON ((468221.1280508253 ...
0
votes
2answers
351 views

query to check srid of features in feature class? [duplicate]

What query should I use to check the SRID of the features in a feature class? The storage type of the feature class in st_geometry? I tried the following query but no luck : select top 1 [...
1
vote
2answers
145 views

Update Oracle DB table from Postgres/PostGIS DB query

I have an Oracle DB where Geolocation (Longitude, Latitude) data is storing. I want to update another column which is the neighborhood of that geolocation. Currently, I do not have oracle spatial ...
3
votes
3answers
344 views

Dynamically update points with xy coordinates in table

I have an Oracle database table with columns for 'X' and 'Y' coordinates. Now I want to display these points in ArcMap. I can use the 'Display XY data' tool for that. My table in the database with XY ...
4
votes
1answer
211 views

Setting DATE as default column type for esriFieldTypeDate in ArcGIS Desktop?

If I use esriFieldTypeDate with ArcGIS 10.2 a DATE column is created in Oracle. If I use it in ArcGIS 10.6 a TIMESTAMP(6) is used Is there a way to set DATE as default column type for ...
2
votes
1answer
1k views

How to view coordinates instead of geometry object in geometry column in Oracle SQL Developer?

I've once found a setting in Oracle SQL Developer, allowing to display the geometry column as coordinates, instead of the generic geometry object name (e.g. MDSYS.SDO_GEOMETRY). I cannot find it ...
1
vote
2answers
612 views

Spatial index info does not appear in ALL_SDO_INDEX_INFO

I have a table with this definition: CREATE INDEX "MYSCHEMA"."MYTABLE_SX" ON "MYSCHEMA"."MYTABLE" ("GEOLOC") INDEXTYPE IS "MDSYS"."SPATIAL_INDEX" PARALLEL 10 ; Geoloc It is a spatial column, but I ...
0
votes
1answer
288 views

Query for tables that are not registered with option to move edits to base

I have an Oracle enterprise geodatabase. In theory, all 500+ tables in the database should be registered as versioned, with the option to move edits to base. However, it has come to my attention that ...
0
votes
1answer
78 views

Oracle Locator Features

I have a road network (in shapefile) which is in a projected system (e.g. EPSG:2100). I also have a number of GPS files in WGS84. I have already stored the data into Oracle 12c (Oracle Database 12c ...
1
vote
1answer
325 views

Reading an OGR VRT with geometry from an Oracle OCI data source

I am having trouble creating/reading OGR VRT files from an Oracle OCI data source. I am running GDAL 2.2.1 on Windows 7 Professional SP1. My data source is an Oracle 11g (11.2.0.4.0) 64bit database ...