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
2
votes
0answers
42 views

ArcMap replication tool does not synchronize changes made in versioned view from SQL Developer!

I am trying to replicate a feature class from Oracle to MSSQL Server using one-way replication(parent-child) replication. The replication works when edits are made from ArcMap,since I have to insert ...
0
votes
1answer
71 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 ...
5
votes
3answers
5k views

Error exporting data from Oracle to shp using ogr2ogr

I have an oracle table which I would like to query/make a selection. I would then like to export the selection to a shp file. I'm using gdal and ogr2ogr. Following the guidelines here and here I ...
0
votes
0answers
47 views

Connecting Oracle Database 11g in ArcMap?

I installed Oracle Database Enterprise Edition 11g(11.2.0.1) in my machine. And I installed ArcMap Desktop 10.3.1 on another machine. Whenever I am trying to create a direct connection of Oracle DB ...
3
votes
0answers
596 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 ...
1
vote
0answers
26 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
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
1answer
651 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 ...
0
votes
1answer
242 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
votes
1answer
142 views

Issues while changing ArcSDE from a Workgroup to Domain Environment

Our organisation was a having a multi-user Geodatabase ( ArcSDE 10.1 gateway on an Oracle 11 g DB) in a Workgroup configuration. The type of Authentication for DB connection was "Database ...
0
votes
0answers
79 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 ...
1
vote
1answer
206 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. (...
4
votes
2answers
65 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 ...
3
votes
0answers
437 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
784 views

Table doesn't match base table schema in Geodatabase Versioning?

ArcGIS 10.1 sp1 with Oracle 11g I've got a versioned feature class that I have discovered has a base table with a different schema than the corresponding A table. (A + registration_id from sde....
2
votes
2answers
2k views

How to copy selected features from one sde feature class to another with different attributes using Arcpy?

I am new to ArcPy scripting, I need help on copying the features to SDE feature class. My Scenario: We have two Geodatabases running on Oracle 11g ArcSDE 10.2. I have been asked to write the Python ...
9
votes
1answer
826 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 ...
2
votes
1answer
73 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 ...
0
votes
0answers
34 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:/...
4
votes
4answers
2k views

Exporting data from Oracle to Esri File Geodatabase grid size error

My specs: ArcInfo 10.1, Oracle 11g I have a line dataset which is sat in Oracle 11g. I can read/query/symbolise this in ArcDesktop without any problems. I now want to export a selection into a file ...
5
votes
2answers
740 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 ...
1
vote
1answer
143 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
3k 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 ...
4
votes
2answers
3k views

What is the best way to migrate an SDE Database

We have a prod database, with an SDE schema. We want to install a new SDE instance 9.3.1 and link it to a copy of the prod database. ArcSDE 9.3.1 on Linux SLES 4 Now, what is the best way to do ...
1
vote
0answers
747 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
2answers
967 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 ...
0
votes
1answer
55 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 ...
3
votes
1answer
433 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 ...
2
votes
1answer
1k views

How do you manage columns in an ArcSDE/Oracle feature class?

Our enterprise has a long history with Oracle and ArcSDE. And lots of tension between the Oracle people and GIS people. Oracle folk often don't like the requirement of using expensive 'nonstandard' ...
-4
votes
1answer
79 views

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

Is it possible to connect ArcMap to Oracle without ArcGIS for Server?
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
69 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 ...
2
votes
0answers
43 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
921 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
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 ...
1
vote
2answers
332 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 ...
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), ...
-1
votes
1answer
228 views

Connecting Oracle and ArcGIS for Desktop? [closed]

How can I Connect between Oracle 64 bit 11g and Arcgis 10.1?
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 ...
10
votes
3answers
908 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 ...
3
votes
4answers
1k views

Shapefile import with Oracle + GeoServer produces points instead of vector shapes

I have implemented the example at http://www.gistutor.com/openlayers/22-advanced-openlayers-tutorials/47-openlayers-wfs-t-using-a-geoserver-hosted-postgis-layer.html and got it working properly. Now ...
1
vote
1answer
248 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 ...
1
vote
1answer
167 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 ...
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 ...
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 ...
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 ...
2
votes
1answer
575 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 +...
2
votes
2answers
1k views

Finding Polygons which do not touch any other polygon in a single oracle database table

I currently have an oracle table of approximately 100,000 records - all of which are polygons. I want to find all the polygons which do not touch any other polygon within the same table. There are a ...
3
votes
2answers
189 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. ...