Questions tagged [oracle-11g]

Oracle is an RDBMS product. Specific releases of the product are known as Oracle9i, Oracle10g and Oracle 11g. Generally there are two releases within each major version. Questions tagged oracle11g are assumed to be specific to this version or features introduced in this version.

Filter by
Sorted by
Tagged with
1
vote
0answers
17 views

Oracle Enterprise GeoDatabase force logging vs nologging [closed]

Our production Enterprise GeoDatabase running on Oracle has been configured at the database level to force logging. ArcSDE DBTUNE defines many tables and indexes by default to be NOLOGGING for ...
0
votes
1answer
57 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
0answers
73 views

Oracle 11g aliases that work in ArcMap 10.4

I am getting this error shown in the picture when I try to export a database view into a GDB table in ArcMap 10.4. I know what is causing the error, its the double quotes I use to create alias names ...
3
votes
0answers
356 views

GeoServer 2.9.2 database connection pooling/thread locking issue

I am mocking GetMap requests. Scenario is that 50 users use only "database layers". Each user "sends" 8 GetMap requests every ~22s for ~300s which sums up to 5200 GetMap requests for vector data. ...
2
votes
1answer
68 views

Geoserver feature type details duplicate Oracle DB users

I have two users in a Oracle DB user_1 and user_2. This issue occurs when I create a two tables by user_1 its show one table as user_1.table_1 and the second table as user_2.table_2. I'm not sure why ...
4
votes
2answers
64 views

Keeping Default Version of Geodatabase protected?

I have a multiuser geodatabase with Oracle Enterprise RDBMS. The Version of the geodatabase is 10.4.1 and Oracle 11g. We have over 35 data editors with the flat version tree, each user having their ...
0
votes
0answers
29 views

How to Drop Indexes on a Table in ArcCatalog

I am using an Oracle 11g database . The code below doesnt allow me to drop indexes on a table. import arcpy # Remove indexes and statistics for gis feature class delta tables COND=r'E:/...
0
votes
1answer
574 views

Errors in creating spatial index on SDO_GEOMETRY column in Oracle 11g

I am using Oracle 11g (Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production) and I have a table that has column of type SDO_GEOMETRY. I want to create a spatial index on this ...
1
vote
1answer
132 views

sdo_aggr_union is not working

I have a table map_building_data and I create view all_incidents_unions CREATE OR REPLACE FORCE VIEW ALL_INCIDENTS_UNIONS ( ORA_GEOMETRY ) AS SELECT sdo_aggr_union (MDSYS.sdoaggrtype (ora_geometry,...
2
votes
1answer
39 views

ArcObjects error storing long integer value to Oracle

I am trying to save a long integer value to an Oracle field. I have created a field of long integer type using ArcCatalog in a standalone table. The below code breaks at row.set_Value(idx, val) . ...
8
votes
1answer
2k views

PostGis vs Oracle Spatial 11g performance

I am having a performance issue updating a table in Oracle Spatial 11G while converting 63,000,000 points to WKT format. I also made a comparison with Postgres. Both Postgres and Oracle run in two ...
0
votes
1answer
52 views

Limiting search radius and improving performance of ArcSDE for Oracle?

I have a feature class with around 1 million polygon features. I'm using the following query to return features from the polygon feature class that intersect a specified point location (x, y not a ...
5
votes
2answers
688 views

Creating geodatabase (and st_geometry) in Oracle Express (XE) for home/personal use?

I'd like to set up a database environment at home that mimics what I have in the office (Oracle enterprise geodatabase/ESRI's st_geometry). I want to do this for spatial database training purposes in ...
3
votes
1answer
403 views

How do I get a list of coordinates from a polygon?

I have a table with polygon geometries and need to get a list of polygon vertices. Using select sde.st_astext(geometry_column) from table_name; I can get the WKT representation of the polygon but I'd ...
-4
votes
1answer
74 views

Connecting ArcGIS for Desktop to Oracle without ArcGIS for Server? [duplicate]

Is it possible to connect ArcMap to Oracle without ArcGIS for Server?
2
votes
0answers
42 views

No data found error when reconciling version in sde

I got an error when reconciling a version in the sde database and it seems sde cannot find the data in one table with a specific STATE_ID (for example STATE_ID = 12345 for table abc). In the delta ...
1
vote
1answer
802 views

Registering database Arcgis 10.2.2?

When I registered a database data store to ArcGIS Server in ArcCatalog, the following error occurs: Underlying DBMS error[ORA-12154: TNS:could not resolve the connect identifier specified No ...
1
vote
2answers
313 views

CreateEnterpriseGeodatabase Oracle Error

Executing: CreateEnterpriseGeodatabase Oracle \localhost\orcl # DATABASE_AUTH sys ***** SDE_SCHEMA sde ***** # C:\Users\Med\Desktop\ags103.ecp Start Time: Wed Sep 21 09:45:00 2016 User does not ...
1
vote
0answers
53 views

Geodatabase configuration keywords

I am trying to insert a new polyline dataset within my Oracle server database. The dataset in question is located within a local GDB, and is currently c420mb in size. It is taking hours and hours to ...
0
votes
1answer
223 views

Shapefile import used mapbuilder to oracle and publish on Geoserver but can't read '_'(underline)

environment:windows10 and oracle11g tools:oracle mapbuilder11 and geoserver2.8.2 step: 1.use mapbuilder to shp file into oracle . like this http://www.duoluodeyu.com/37.html 2.create a link with ...
1
vote
1answer
243 views

Calculating all possible lat & long

I am new to GIA domain. I am trying to learn new concepts around mapping etc and this is my first app/implementation. I am trying to implement a store locator kind of function. I am thinking to ...
4
votes
1answer
53 views

Are ESRI spatial views regenerated whenever they are queried?

If a spatial view contains data "joined" from multiple tables, will all the tables be queried whenever a query is executed against the spatial view? We have some spatial views and whenever we run a ...
1
vote
1answer
156 views

Deleting features with arcpy on ArcGis SDE 10.0 SP5

I am new to ArcGIS and arcpy and am learning largely through trial and error. Anyway, the overall task is to delete, edit and add rows to feature classes. I thought it would be good to start with ...
0
votes
1answer
64 views

ESRI oracle multi editor schemas

Solution: The limitations of the Esri + Oracle (per 12c) were the cause. 12c Oracle will allow for Multi-Tenant DB, allowing us to have multiple SDE GeoDB as we need. This will meeting the need for ...
0
votes
2answers
923 views

ArcGIS 10.1 crashes during connection with ArcSDE 10.2 in Oracle 11g database

I have been having this issues of ArcGIS (ArcMap and ArcCatalog) crashing on me every time I try to connect to the databases. I have updated both client and server patches for Oracle as suggested by ...
10
votes
3answers
864 views

Querying for underscore character in ArcMap?

For a standard LIKE query against an Oracle-based ArcSDE feature class, the underscore character represents a single character wildcard when used with a string. I'm trying to impose a definition ...
2
votes
2answers
2k views

Creating spatial view from materialized view?

I have a materialized view that runs nightly and performs an intersection of point locations and polygons. The materialized view works as designed and returns the desired results. It contains ...
4
votes
1answer
1k views

ArcSDE 10.1 Insert/Update Trigger on Adds (A) Table (Oracle 11g) and Feature Services on ArcGIS Server

I'm trying to use a trigger to update a versioned dataset in an SDE environment. Basically, I wanted to implement a system of unique ids called GISID. Initially, when a feature is created (inserted), ...
2
votes
1answer
560 views

Projection Problem on Oracle Spatial

I would like to transform SDO_GEOMETRY from WGS84 projection to my custom projection in Oracle Database. Details for custom projection is as follows: +proj=lcc +lat_1=40.5 +lat_2=37.5 +lat_0=25 +...
3
votes
2answers
179 views

Do I need to use ESRI's Create Spatial Type functionality

Does anyone know if I need to use ESRI's Create Spatial Type functionality when creating a field in a non ESRI / non geodatabase Oracle 11g database? I have an older customer database in Oracle. ...
2
votes
0answers
180 views

Controlling precision of coordinates returned from ArcGIS for Server service?

I have a REST service that returns shapes as json. The shapes represent various natural features. The problem is the precision of the coordinates. Currently, 11 decimal places of precision are ...
1
vote
1answer
202 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. (...
1
vote
1answer
68 views

ArcMap 10.3.1 Editor Message: “A layer for PROJECT_LINES was not found…”

When editing a feature class stored in Oracle Spatial, I am receiving 3 warning messages upon stopping the edit session: There are 2 more after pressing OK - PROJECT_POINTS and PROJECT_POLYGONS. I ...
0
votes
1answer
679 views

How do I create a point, buffer it, and intersect with polygon geometry?

The sql below is intended to create a point from a know X,Y. It should then buffer the point with a known distance. Last, the sql should intersect the buffer with an underlying polygon layer and ...
4
votes
0answers
619 views

How to hide system tables of oracle in sde connection?

I connected to oracle 11g r2 with ArcGIS 10.2 using SDE connection. The connection is ok but in the connection i see system tables of APEX_030200 and other schemas. Same question is in the Geonet ...
3
votes
1answer
4k views

Connecting to Oracle database with ArcGIS for Desktop?

I installed ArcGIS 10.2.2 ,oracle 11g R2 personal edition and it's client.I try to connect to the database using database connection in ArcMap but the error Failed to connect to the specified ...
2
votes
1answer
287 views

Select by attributes for Arabic fonts in SDE/ file geodatabases?

I have a layer with names of electrical substations in Arabic language. there is no any problem when searching any Field names in English language whether from the SDE of file goedatabase I got the ...
3
votes
1answer
527 views

How are orphan gsrvr.exe processes created?

I just inherited a server running SDE application server 10.1 against an Oracle 11g database. I'm finding that many connections are not getting properly dropped and stay on as Orphans. Eventually the ...
0
votes
0answers
37 views

How to model multiple topology classes in one query with ArcGIS

We have a lot of geographic data with different geometry type in our application, which are persisted in the Oracle 11g database with ST_Geometry supported by Arcgis SDE 10. The features can be ...
1
vote
0answers
730 views

Spatial query by ESRI ST_Geometry take too long

I am using ESRI ST_Geometry in my application, and I found that the spatial query is rather slow: The following sql is used for query pois inside a certain bounding_box: select * from ( select ...
0
votes
1answer
746 views

How to update extent via sql (st_geometry) from ArcGIS for Desktop?

how to update extent via sql (st_geometry) using arcgis 10.2 i've noticed that if one inserts a geometry, let's say a point, into a table via st_geometry, the corresponding table extent is not ...
1
vote
1answer
414 views

How do I insert a date string into the database as a date?

I'm using an InsertCursor to insert rows into a feature class. One of the fields in the source data may contain a NULL data value. The destination feature class requires a date - it is not nullable. ...
0
votes
0answers
56 views

How do I synchronize field properties with the database properties?

I have a feature class with a property that is out of sync with the database table. The field property is "Allow NULL values" and it's currently set to "No". Earlier today, before I was aware of this ...
1
vote
1answer
125 views

QGIS Web Client Raster not visible

I have loaded rasters from PostGIS and Oracle Spatial 11g with below script. Both layers are visible in QGIS Dekstop. My OWS settings are correct but the Oracle raster layers are not visible in QGIS-...
1
vote
1answer
164 views

Load Oracle Spatial Raster using PyQGIS

Able to connect to Oracle Spatial 11g and print tables with SDO_GEORASTER attribute both in QGIS python console and standalone application.I get below error when loading rasters from oracle Table. ...
2
votes
1answer
543 views

Load PostGIS or Oracle Spatial Raster Layer using PyQGIS

How do we load Rasters stored in PostgreSQL-PostGIS or Oracle Spatial 11g into QGIS using PyQGIS? I am able to load vector layers from Oracle 11g with below code. What changes are necessary to add ...
0
votes
0answers
897 views

Export to Oracle using QGIS

I have loaded a shapefile into QGIS and I now want to export it into our Oracle Database and add SDO_GEOMETRY. Is it possible to do this directly in QGIS? If not, what opensource options do I have to ...
5
votes
1answer
4k views

How to configure ST_GEOMETRY Access for Oracle 64 bit?

I'm trying to configure the Oracle extproc to access the geodatabase with SQL, using the documentation here. This is a Windows 2008 R2 server with 64 bit, and the Oracle server is also 64 bit. I'm ...
8
votes
1answer
792 views

Out of Server Memory when reconciling a large edit session in ArcObjects

One of our users has been periodically experiencing Out of Server Memory errors with ArcSDE 10.0 when trying to reconcile a large edit session. VMware ESX Instance: Windows Server 2008 R2 Datacenter ...
5
votes
2answers
1k views

How do you determine which dbclient connection property to use for an Oracle SQLWorkspace connection?

I have an Oracle11g database that I connect to via a SQL Workspace; however the actual dbclient string value that works differs depending on machine (and I'm guessing oracle client configuration). On ...