Questions tagged [oracle-dbms]

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

63 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
0answers
205 views

QGIS Oracle Schema Connection

In QGIS is there any way I can connect to and list tables for only one specific schema (among many schemas and not the same schema as my username) in oracle? In the "Create New Oracle connection" box,...
4
votes
0answers
497 views

Creating materialized view from ArcSDE layer

In the past I've used materialized views in Oracle to replicate non-spatial data from one database to another. I'd like to do the same thing with an ArcSDE feature class, but I'm wondering how that ...
3
votes
0answers
505 views

AttributeError: OracleDBConnector instance has no attribute 'cache_connection' in QGIS DBManager

I have a connection with an Oracle Database but when I try to make a query using DB Manager of QGIS it appears "Not Connected" and I get a Python error: 1 Traceback (most recent call last): ...
3
votes
0answers
583 views

Update sde.st_geometry M values to cumulative distance (geometric length)

I'm trying to write a query to update sde.st_geometry M values to the cumulative length of a line. The M values in my route feature class are purely based on the geometric length of the line. The ...
3
votes
0answers
644 views

Geodatabase Connection to Oracle Active Data Guard Standby

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 Oracle Database 11g R2 ArcSDE for Oracle 11g 9.3.1 ...
3
votes
0answers
773 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
241 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
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: ...
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 ...
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 ...
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 ...
2
votes
1answer
155 views

What permissions needed to add an index with a protected version?

Using arcpy and ArcGIS 10.1 SP1 (Build 3143) against an Oracle 11g enterprise geodatabase, I am trying to add an index to an existing attribute in an existing feature class: arcpy.AddIndex_management(...
2
votes
0answers
183 views

Esri ST_Geometry function to make line from points

I'm attempting to write a SQL statement that joins two point feature classes, both in an Oracle ArcSDE geodatabase using ST_Geometry, and selects a line geometry connecting the points of each ...
2
votes
0answers
121 views

Regarding QGIS Connectivity To Oracle

I installed QGIS long term release today first 64 bit and second 32 bit. My problem is that SQL Developer for Oracle a non QGIS product does connect to Oracle and when I use the same credentials in ...
2
votes
0answers
226 views

Different SRID problem

I have two geodatabases and I import a large number of tables from one to another by using ArcCatalog (ArcGIS 10.2). However the tables and indexes created on them are imported with different srid. ...
2
votes
0answers
686 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
72 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
54 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
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 ...
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 ...
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 ...
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
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 ...
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.
1
vote
0answers
18 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 ...
1
vote
0answers
74 views

ArcPy Editor commits in batches of a thousand records dropping some records

I am copying data from one database to another using arcpy cursors. This is an Oracle enterprise geodatabase against a versioned dataset. Using Python 2.7 and ArcGIS 10.1. The following code has ...
1
vote
0answers
373 views

How to extract Latitude and longitude from ArcMap using Oracle as a database

I'm facing a problem to convert my data on Oracle and I've already searched this topic on internet, but nothing gives me the elegant or simple solution. I have an ArcMap where connect to database ...
1
vote
0answers
57 views

FeatureClass.Search freeze

ArcMap add-in is freezing on .Search() by spatial filter. Here is my code, for ArcMap add-in 10.3 version. When I used it with Oracle databases, happens only on one instance, works perfectly with ...
1
vote
0answers
359 views

Connecting ArcMap to Oracle DB

I am trying to establish a connection from ArcMap 10.0 -- Service Pack 5 to an Oracle DB (I thought it was 10g if might be 11g) on windows 7.. It is windows have connected to the database via Catalog....
1
vote
0answers
101 views

How to compile QOCI in QGIS master?

I am trying to compile QOCI in QGIS master, I followed the instructions, directly from QT, but I still get the same error: "fatal error: QtSql / private / qsqlcachedresult_p.h". I am working on a 32 ...
1
vote
0answers
297 views

Esri ST_Geometry functions too slow on Oracle

I'm writing an SQL statement to create a feature class and using st_geometry functions. But it's taking too long. So I begin the statement with a join, which is taking 150-200ms SELECT PRC.OBJECTID ...
1
vote
0answers
98 views

Can OVERLAPBDYDISJOINT or ON ever occur between two polygons?

Oracle uses a series of specific spatial relationships to indicate the how different shapes interact with each other. Two of the relationships it describes are somewhat odd: OVERLAPBDYDISJOINT: ...
1
vote
0answers
240 views

Find midpoint of street geometry,with grid lines

Currently my application displays street name in middle of whole street, but when we use grids,we want to display street name in middle of street under grid,I want to calculate midpoint of street ...
1
vote
0answers
90 views

Why does an empty, non-spatial table get flagged as Is_Simple=False in an SQL query?

I've created an empty table in an Oracle geodatabase. It was created in ArcCatalog by using the catalog tree >> New >> Table tool. The table is registered with the geodatabase and is not registered as ...
1
vote
0answers
48 views

Accessing ORACLE table from QGIS gives TNS-12545 error?

I have to access one ORACLE tab from QGIS but it does not work. From Instantclient_12_1 the connection and parameters are ok, while from QGIS we always get TNS-12545 error. ORACLE_HOME and TNS_ADMIN ...
1
vote
0answers
794 views

Geoserver 2.7 - 'Bounding Box & Lat-Long Data' fetching problem from Oracle Locator database

I have installed Geoserver 2.7 & connected my Oracle (Locator) database with available 'gt-jdbc-oracle-13.2.jar' extension. During layer publishing containing fields like 'Geometry', it failed to ...
1
vote
0answers
163 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
191 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
130 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
250 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
89 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
2k 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
0answers
97 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
177 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
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 ...
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 ...
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 ...
0
votes
0answers
41 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 ...
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 ...