A commercial relational database management system.

learn more… | top users | synonyms

2
votes
3answers
397 views

Is it possible to create Domains for an Oracle (non SDE) database?

I have a simple Oracle database (non SDE/Geodatabase) but I want to constrain the values that can be entered into a particular field (ex: the state names that can be stored/entered in a "State" field) ...
2
votes
3answers
670 views

Definition Query to Python script on Oracle 9i and ArcGIS 9.3.1

SUBTYPECD=1 AND SERIESNAME NOT LIKE '%-%' AND OPERATIONALSTATUS IS NULL OR SUBTYPECD=1 AND SERIESNAME NOT LIKE '%-%' AND OPERATIONALSTATUS = 976 The above is my def query in ArcMap against ArcSDE ...
0
votes
1answer
137 views

Is there a way to automatically run the Workflow Manager Postinstallation (WMXPostInstallation.exe)?

I'm looking for a way to script the WMX post-install and, for example, provide the sde connection info as parameters. I don't see any command-line parameters for WMXPostInstallation.exe--are there ...
1
vote
3answers
983 views

ArcSDE & Oracle & Database Model — Best diagram the system

Having Oracle dbms with ArcSDE and ArgGIS Pipeline Database Model (APDM), I would like to best describe the system with a diagram. In MS SQL each db is autonomous, I think, meaning ArcSDE(using dbo ...
7
votes
3answers
3k views

Technical comparison of Oracle and PostgreSQL

I have searched on google and the archives for a technical comparison of Oracle and PostgreSQL (also MySQL), unsuccessfully. Is there any comparison that covers more than just the basic differences? ...
4
votes
1answer
389 views

Migration from Oracle to PostgreSQL

I emphasise that I am a newbie in databases. Is it possible to migrate from Oracle database to Postgres? If yes do you know any tested solutions?
3
votes
1answer
1k views

Can spatial data in Oracle be imported into SQL server?

Oracle supports spatial data and so does SQL Server. What are the things to consider if we have to migrate spatial data from Oracle to SQL Server? Are there any features in Oracle that are not there ...
4
votes
3answers
2k views

Spatial Views in SDE - What causes them to become unregistered from the geodatabase

Spatial views in ArcSDE allow you to join columns from a 'non-spatial' table in the database to a table with a 'geometry column'. They can also allow you to format and choose the attribute columns ...
2
votes
1answer
528 views

Filter features with multi-table joins in ESRI Silverlight/REST API

We have a rather involved data warehouse (SDE 9.3.1 / Oracle 11g) that contains a single related point feature class. Our (analytical) application should allow users to construct complex, ad hoc ...
3
votes
1answer
1k views

gp.Describe() on sde table

Python newbie needing help with a simple task. I'm trying to create a list of stand-alone tables in an sde workspace. Code below works just fine to list feature class names and paths and table ...
2
votes
1answer
441 views

Oracle tracing, bind variables, and ArcSDE

Oracle tracing with TKPROF is the recommended way to troubleshoot data access performance problems with SDE/Oracle. Unfortunately, queries that differ in any way are considered "different" and ...
3
votes
2answers
450 views

Is there a common interface for ST_Geometry SDO_Geomtry

I've worked a fair bit with Oracle Spatial and I've had some requests to transition to PostgreSQL Spatial. Is there a common interface for SDO_Geometry and ST_Geometry? I'm working in Java with ...
5
votes
1answer
214 views

Versioning commercial datasets in ArcSDE + Oracle

We are building an application with several spatial tables, provided by a commercial vendor, at its core. The vendor provides updates quarterly. We maintain several tables of our own, derived from ...
2
votes
2answers
680 views

How to add a Database Server in Catalog?

I have ArcSDE on an Oracle database and I want to add a database server connection to ArcCatalog, I've seen several sites but they don't say what I have to write down. Let me explain: From the tree ...
4
votes
1answer
955 views

In Oracle Spatial, what is the fastest way to determine the percentage of intersection between two shapes?

I have to query polygons that intersect with one another. Our polygons occasionally contain intersections that aren't intended (meaning just a few vertices cross boundaries). I want to filter out ...
2
votes
1answer
688 views

ArcSDE: connecting via LDAP Authentication

I was wondering if anyone has a sample connection string for SQLPlus using LDAP Authentication. I am also trying to specify in the connection string the database I wish to use. Thanks, CDB
0
votes
1answer
290 views

Convert geodata from .rdb and .mpr files

I've got an COM-server and activeX client (looks like delphi app), that display some geodata. Data stores in files with .rdb and .mpr extensions. I find out that rdb is oracle database file format. ...
1
vote
0answers
143 views

Can I get the metadata about the themes in Oracle MapViewer?

I am trying to use the MapViewer xml api to generate a dynamic theme (for generic highlighting support), but don't want to expose table names and such to users, I would like then to communicate in ...
3
votes
1answer
744 views

Unable to Reconcile

I'm quite familiar with the ArcSDE model and a few days ago we have major power issues here. My problem (and this is a BIG one) is that one of the users, made thousands of edits correcting data, and ...
5
votes
6answers
5k views

Troubleshoot editing features in feature dataset with ArcMap / ArcSDE Oracle

I am having trouble editing a feature class that is in a feature dataset. We have added just the single feature class as a layer in ArcMap and are using the "Start Editing" function on the Editing ...
3
votes
2answers
1k 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, ...