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 oracle10g are assumed to be specific to this version or features.

learn more… | top users | synonyms

3
votes
0answers
52 views

Changing workspace path of query layer using ArcPy?

I'm trying to change the workspace path of a query layer using the code below and it always breaks. The layer is connected to a view in an Oracle Spatial 10g database. The database is SDE enabled ...
2
votes
2answers
109 views

Get Coded Value Domains from a Oracle geodatabase using PLSQL

i'm trying to get all coded value domains from a Oracle geodatabase. I dont have access to arcmap. I only have access to oracle 10g database. SELECT I.NAME Domain, ...
0
votes
0answers
22 views

WhereClause to get the row with least datediff to given date

I have an SDE running on Oracle10-database from that I need to retrieve that row that has least datediff to a given date. So I tried to order the rows and get the very first row, but I do not have a ...
1
vote
2answers
4k views

Error:The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception

I am developing custom geoprocessing tool (class-library project) on ArcGIS 10.2. This project uses Oracle.DatAccess from ODP.NET 1.0 . This is a simple tool which queries - oracle 10g database and ...
3
votes
0answers
1k views

Error opening feature class from SDE (which can be opened in another application)

We're using ArcGis 10.1 with ArcSDE 9.3.1 on Oracle 10g. I've got 2 layers that cannot be opened or modified with ArcCatalog or ArcMap (but they show up in the list. Everything worked just fine ...
2
votes
1answer
2k views

ArcGIS 10 querying Oracle 10g without SDE

I'm interested to see if anyone has successfully got this setup working, and if so how many sacrifices were required and to which deities. I am hoping to ultimately get ArcGIS Server 10 serving map ...
3
votes
1answer
300 views

TO_DATE query on ArcSDE for Oracle dataset failing?

I'm trying to use TO_DATE to query an Oracle SDE dataset. It's not working in the javascript API application so I tried to query the rest end point directly and I get the error: "Unable to perform ...
3
votes
1answer
860 views

Using primary keys with ArcSDE (Oracle)?

Is it possible, more advisable to assign a primary key to the OBJECTID column in a featureclass in SDE. I am using Oracle and some of my flat tables (junction tables) need to SEE a primary key in the ...
6
votes
2answers
2k views

In a versioned geodatabase, what impact do delta tables and the state tree have on query performance?

We have a versioned arcsde geodatabase (arcgis 9.3.1 on oracle 10g) with a fairly complex data model that includes about 100 featureclasses and non spatial tables, a geometric network and many ...