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
1
vote
2answers
986 views

Create a geoserver SQL view from Oracle SQL using a lat and lng column

I have a table in a Oracle SQL database in which I have a polygon geometry and two more columns of latitude and longitude. What I need is to show the points of lat and lng in a layer in geoserver. I ...
1
vote
2answers
462 views

ArcGIS 10.2 Query layer ID field using double / floating field?

I am using ArcGIS for Desktop 10.2. Am I correct in understanding that ArcGIS will only let you select an integer or text fields as the "key" ID when adding a query layer? Our Oracle enterprise ...
1
vote
1answer
726 views

Refresh Database Connection in ArcCatalog

I have created a feature class in an Oracle 11g database connection with ArcCatalog 10.2 (without ArcSDE) and I can see the table in the database with Sql Developer without problems. But, if I drop ...
1
vote
1answer
288 views

Arc 10.2.2 crashes when adding query layer? [closed]

I'm trying to add a query layer from an Oracle database into a blank 10.2.2. map. I enter the query, validate, finish, and the software thinks for a second and then just winks out. No error message,...
1
vote
1answer
377 views

Postgis/SpatiaLite SQL query to connect MySQL, Access or Oracle database

In SpatiaLite or Postgis, how can one create a SQL query to read a table from a MySql or Oracle database? I don't know **the correct SQL syntax to connect to a table in a MySql or Oracle database **....
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 ...
0
votes
0answers
218 views

Using ArcPy Insert Cursor with NEXTVAL of Oracle sequence?

I have the need to be able to set a value of a gdb table to the NEXTVAL of an Oracle sequence. I have to be able to do this through an ArcPy function that will also handle setting the ArcPy OBJECTID ...
7
votes
2answers
2k views

QGIS DB Manager Import layer/file Oracle not working - Error 8 Loading of the layer failed

QGIS 2.12.0 - DB Manager 0.1.20 - Windows 7 - Oracle 11g 11.2.0.3.0 Import vector layer Shapefile as well as a layer (vector) and with every possible combinations of settings, the results are the ...
1
vote
1answer
213 views

Esri ArcSDE 10.3.1 Query Inspire Metadata from Oracle (11g) Enterprise GeoDB via SQL

As the title says - I want to create a query in Oracle SQL which will read all dates from the geoprocessing history which can be found using ArcCatalog to show the "Description"-tab from a feature. (...
3
votes
2answers
459 views

Provide credentials for Oracle database when opening MXD file?

I need to open a MXD file from a Python toolbox (so that I can automatically export it to a PDF). The file contains a connection to an Oracle 11g database, and I need to somehow provide the ...
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
1answer
3k views

Update a table with values from coordinates on GEOMETRY in Oracle

I have 2 columns in a table that represent the X and Y coordinates. The values in those columns don't match the actual coordinates and I want to update them with the coordinates values that are ...
1
vote
1answer
403 views

How to set a specific ArcSDE version for tabular reporting?

I have created a multiversioned view in Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production. I can access a specific version using a SQL script in SQL Developer. However, using ...
2
votes
2answers
429 views

Is it possible to lock records or attributes indefintely if a field is populated?

I am creating a c# ArcGIS addin where I have a feature class stored in Oracle, when a feature is created some of the fields within the table will be populated. If field X is populated, then certain ...
1
vote
2answers
3k views

Querying Oracle geometry data type

How to query or find the geometry data type a given Oracle Database is using in SQL Developer (i.e. SDO_Geometry, ST_Geometry, etc)? I thought I could just describe a feature class within the ...
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 ...
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 ...
0
votes
2answers
4k views

Error connecting to SDE 10.3.1 on Oracle 12c from 10.1 client

We are currently planning an server migration. We have our current server on SDE 10.1 on Oracle 11 Currently our editors are on ArcGIS 10.1 with Oracle client 11.2 Our new server is setup and ready ...
0
votes
2answers
69 views

different calculation results

I spend a comparison of functions of spatial analysis and Oraсle postgresql. There are two tables with the same coordinate system - tech_bridge. oracle query select sum(SDO_GEOM.SDO_AREA(t....
3
votes
2answers
245 views

Switch between test and production database in ArcMap?

I have two Oracle 11g databases, one for testing (tst.world) and one for production (prd.world). Except when I am trying out new things, they have exactly the same table structure. In ArcCatalog I ...
2
votes
2answers
282 views

Where are Object class extension GUIDs stored in Oracle?

Where are the GUIDs for object class and workspace extensions stored in SDE for Oracle? I've looked through GDB.ITEMS but can't seem to find it. I think SQL Server stores it in an .xml column but I ...
1
vote
2answers
279 views

AddIndex_Management throws maximum open cursors exceeded

The following script is run to create indexes across all the feature classes within a particular dataset: import arcpy import os.path def listFcsInGDB(): for fds in arcpy.ListDatasets("FRED.GS*",...
2
votes
2answers
2k views

How to programmatically import a Shapefile into Oracle DB using Java?

What's the best approach to import a user uploaded shapefile into an Oracle DB? The dbf, shx and shp files of the Shapefile come in a ZIP Archive. Currently, we unzip programatically and then parse ...
0
votes
1answer
715 views

Geoserver: WMS layer is shifted at certain zoom scales in openlayers

We use geoserver to serve WMS tiles inside a openlayers environment. The weird thing I see is that, in our production environment, depending on the scale, data is shifted (translated) against the OSM/...
1
vote
1answer
546 views

Upgrading from sde 9.2/oracle10g to sde 10.2/oracle11g

I have an old geodatabase created using Arcsde 9.2 on Oracle 10g. Now, I'm trying to update it to new system using ArcSDE 10.2 on Oracle 11g r2. Because SDE 9.2 schema and SDE 10.2 are not ...
2
votes
1answer
116 views

Why value relation doesn't work when I delete and connect reference layer?

I'm trying to connect reference table (domain) with data(text) to my vector layer (id's) using value relation. I have database in Oracle connected. It works fine, but when I delete the reference layer ...
1
vote
0answers
222 views

Keeping DEV, UAT, and PROD environments in sync with ArcSDE for Oracle? [closed]

Recently, I was doing some development work against our DEV environment. It seems logical at the time. When nearly complete, and after much face palming, I found the DEV environment was way out of ...
0
votes
2answers
296 views

Monitor Traffic Between ArcGIS Server and Oracle DB

So, my dba informed me yesterday that ArcGIS Server made 40+ million requests to Oracle in a 20 minute period. That would be approx. 35k requests per second. I started laughing, and said we have the ...
1
vote
1answer
382 views

ArcSDE - spatial index grid size for empty table

I'm trying to write the SQL to create a feature class and spatial index in an Oracle SDE geodatabase using ST_Geometry. This is how I'm making the table: CREATE TABLE STREETS (ID NUMBER(11) NOT NULL ...
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 ...
2
votes
1answer
777 views

Taking a long time to load tables from oracle to QGIS

My workplace has an oracle database with a very large number of spatial tables. Therefore, it takes a long time to load the oracle connection in QGIS. Does anyone know how this could be speed up?
0
votes
0answers
868 views

Using St_geometry in oracle 11g

We are using ST_Geometry for Oracle 11g at the moment. And we need to query features (points,lines,polygons in a view) inside a given extent(either a circle or a polygon or a rectangle), and we use ...
0
votes
1answer
444 views

Geomedia Smart Client features, Oracle database

We have database schema imported in Oracle, but when we want to import it into Geomedia Smart Client (GMSC) certain tables are not visible in GMSC. On the other hand, VIEW created from these tables ...
1
vote
1answer
730 views

ArcObjects / Oracle12c / EZCONNECT

i am having some trouble connecting to Oracle12c via ArcObjects and EZCONNECT. Results so far: • Can connect via ArcCatalog 10.2.2 using an *.sde file. (EZCONNECT) • Can connect via ...
0
votes
2answers
2k views

Set encoding when using ogr2ogr to export from Oracle db to MapInfo table?

I am trying to automate the export of spatial data from a oracle database to mapinfo .tab files. Using this thread I made my script. However I can't see how to set the encoding right. My data have ...
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 ...
3
votes
2answers
752 views

GeoServer- Reload feature type doesn't work [closed]

I have Oracle database and I had created layer in GeoServer. It had worked good, but when I recreated database with different table structure (some columns dropped, some new added), I've got a problem....
1
vote
1answer
1k views

Insert SDO_GEOMETRY in cx_oracle

I have many polygons to insert. This code is ready to use. geom_str = '"MDSYS"."SDO_GEOMETRY"(2003,NULL,NULL,"MDSYS"."SDO_ELEM_INFO_ARRAY"(1,1003,1),"MDSYS"."SDO_ORDINATE_ARRAY"(-735342,-1010550,-...
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. ...
1
vote
2answers
1k views

Privileges for Oracle users created using the ArcGIS Create Database User tool

I've created an enterprise geodatabase on Oracle. I can connect to it from ArcCatalog and from SQL Developer using the SDE user. I've created a new user named GFPTest using the Create Database User ...
3
votes
1answer
667 views

Is it possible to get column names from an ArcSDESQLExecute SELECT execution

I am running ArcGIS 10.0 desktop and querying an Oracle 11g database and writing the results of a SELECT statement out to a CSV file. Everything works great; however, I would love to find a way to ...
0
votes
2answers
553 views

Oracle Error 00936 in ArcMap

I am using ArcMap 10.2 and have connected to my Oracle database, and can see the tables in Catalog. However, when I try to add a layer I get "Could not add the specified data object to the map. ...
2
votes
1answer
286 views

Database connection times - PostGreSQL vs Oracle (ArcSDE)

I have 2 SDE instances. Both have the same amount of data (2000 datasets both raster and vector). One is PostGreSQL 9.2 with ArcSDE 10.2.1 One is Oracle 11g with ArcSDE 10.2.1 So basically the only ...
0
votes
0answers
504 views

ESRI ST_Geometry struct parse in java

I am trying to read and parse the ESRI ST_Geometry which is an oracle user defined type in java manually, and I follow this instructions, and it said that: .... Points: Contains the byte stream of ...
0
votes
2answers
1k views

How to troubleshoot “RuntimeError: The field is not nullable [Column_Name]”?

I have a python (arcpy) script that extracts data from a database table, processes it, and inserts into a feature class. It works in my development environment but not in production. I recently ...
2
votes
1answer
409 views

How to identify Unposted/Outstanding (A&D) edits of a version in Enterprise SDE Database using SQL interface?

I am working on ArcSDE10.2.2 Oracle11G(11.2.0.4) enterprise geodatabase with user base 600+ and 2000 versions( Created from DEFAULT). For effective GDB compression and optimized performance delta ...
0
votes
2answers
827 views

Does hibernate spatial support st_geometry created by ArcSDE?

We are using ArcSDE 10.0 to export data to the Oracle database, and the spatial property are saved using the SDE.st_geometry format. Now in our J2EE application we tried to manage these data by ...
2
votes
1answer
111 views

Oracle VectorLayer without geometry - How to get attributes?

I have a problem to iterating over a oracle VectorLayer without geometry in QGIS 2.6. self.uri = QgsDataSourceURI() self.uri.setConnection("localhost", "port", "xe", "name", "password") self.uri....
2
votes
1answer
8k views

Bulk inserting with Python and cx_Oracle into st_geometry enabled table?

I'm trying to make a bulk insert of a CSV file with Python and cx_Oracle into an st_geometry enabled table of an Oracle database with ArcSDE. I could do it with the method execute() of cx_Oracle but ...
0
votes
0answers
618 views

Delete user on ArcGIS server against Oracle backend

I have a problem, when we delete users, using the following command: drop user sdedata cascade; We get the this error: ORA-00604: error occurred at recursive sql level 1 ORA-21700: object does ...

1 2 3
4
5
7