A commercial relational database management system.

learn more… | top users | synonyms

14
votes
3answers
2k views

ArcObjects: Memory leak in IFeatureClass.Search (only on SDE with direct connect)

UPDATE 6/30/11: ESRI Support say they have reproduced the issue and have opened a bug report (NIM070156). I have determined that there is a memory leak (in unmanaged heap memory) that occurs when a ...
8
votes
2answers
323 views

How to determine storage type (ST_Geom/Oracle) from arcpy/python

We're migrating some feature classes from SDELOB (or some older binary format) to ST_Geometry. As we write our arcpy script to use the ESRI Migrate Storage Tool we'd like to test whether or not ...
4
votes
2answers
624 views

How to allow more polyline vertices for a ST_GEOMETRY in Oracle/SDE?

I'm receiving an error writing geometry (in ArcObjects) that has a large number of vertices (around 900). So big, but not ridiculously big. I would expect this to be no problem and I don't recall ...
2
votes
3answers
976 views

Tracking change with ArcSDE/Oracle

I'm looking for the simplest way to track changes ([delete, update, create] feature(s)) made to the DEFAULT version of a given feature class in ArcSDE(10) and Oracle(11g). Qualifier: I am not a dba ...
4
votes
1answer
512 views

Joining spatial and not spatial table in oracle

I have spatial table with rows of data representing polygon(A). I have another table that contains values for polygon field(B). Now I would like to join these two table and create a spatial table. I ...
0
votes
1answer
186 views

ArcGIS - Help Using Oracle Function in Definition Query - No ArcSDE

I have set up a Query Layer pointing at an Oracle table with a SDO.Geometry column, and that is working and behaving fine. However, when I am attempting to set up a definition query that calls a ...
0
votes
3answers
222 views

For a SDE FeatureClasses list all Roles that have been Granted any Privileges on it, and which Privileges each Role have on it

I have searched through the ArcObjects 10 SDK API and googled, but havnt been able to find what I am looking for, so thats the reason for me posting this question. Q: How can I for a SDE ...
0
votes
1answer
151 views

SDE FeatureClass Granting and Revoking Privilege with ArcObjects

Q: How can I with ArcObjects GRANT or REVOKE Privileges like SELECT, UPDATE on SDE FeatureClasses to/from Roles? The equivalent in normal Oracle would be something like this: GRANT SELECT ON ...