Skip to main content

All Questions

Filter by
Sorted by
Tagged with
1 vote
1 answer
962 views

Unknow error connecting from ArcCatalog to Oracle

Currently I am running ArcMap 10.6.1 and try to connect with an Oracle 19c database. Unfortunately I only see "Unknown Error": Underlying DBMS error[Unknown errorNo extended error.] Yet I ...
Riccardo's user avatar
  • 2,677
0 votes
0 answers
579 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 ...
Ramu's user avatar
  • 1
0 votes
0 answers
142 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 ...
Thomas_'s user avatar
  • 143
11 votes
3 answers
2k 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 ...
Eok's user avatar
  • 759
0 votes
0 answers
156 views

View With SDO_GEOM Function for ArcMap

I have a table of boundaries(polygons) which need to be served up through ArcGIS Server with their centroids(points). I'm using Oracle spatial and thought the most efficient way of doing this was to ...
user1567453's user avatar
0 votes
2 answers
814 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. ...
user44994's user avatar
0 votes
1 answer
632 views

Creating a layer in arcmap by dragging a table from an OracleDB

I am working on a project for a client, they gave us some data from their oracleDB, and when I connect to it in arc map I can just drag and drop the tables from the catalog window into arcmap and they ...
branchini's user avatar
  • 177
2 votes
0 answers
427 views

ArcMap vertex problem for Z-value

I have an Oracle Spatial dataset with z-coords. I can edit the dataset in ArcMap however the z-values are always rounded to the nearest integer. Why does ArcMap round the z-values?
Pieter Minnaar's user avatar
3 votes
2 answers
2k views

ArcMap Query Layer passing invalid SQL to Oracle

In two different environments I'm having trouble using ArcMap 10.0 SP3 Query Layers to view SDO_GEOMETRY (point) data in Oracle 11.2 (11gR2). Points are in Oracle stored under SDO_GEOMETRY, 2001 type (...
tomfumb's user avatar
  • 3,698
3 votes
2 answers
2k views

Cannot spatially select from Oracle view based featurelayer in ArcMap

I'm hoping someone has seen this before and has a solution. I've exhausted all my ideas. I having problems with the selection and identify tool in ArcMap. I have a point feature class, zlevels, ...
mfowler's user avatar
  • 345