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

2
votes
2answers
90 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
19 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
3k 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
288 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
832 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
1k 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 ...