Questions tagged [oracle-dbms]

Use for questions about Oracle DBMS that are not about its Spatial or Locator extensions

Filter by
Sorted by
Tagged with
16
votes
3answers
4k views

Addressing Memory leak in IFeatureClass.Search (only on SDE with direct connect) of ArcObjects?

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 tool in my .NET/C#...
13
votes
6answers
5k views

Identifying true curves/arcs in ArcMap?

The only good way of creating circles in ArcMap is using true arc, (compound curves) but I need to convert those to vertex (densifying) because of a compatibility problem. I need info for geodatabase ...
10
votes
3answers
1k 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 ...
8
votes
7answers
9k 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 ...
8
votes
3answers
419 views

What technology is used behind ArcPy cursors?

I'm using ArcGIS Server 10.0. I have a geoprocessing using arcpy search, update and insert cursors. I'd like to know more about the technology behind these cursors. Does it use any driver or pool to ...
8
votes
3answers
1k views

Can primary keys and foreign keys be used in versioned geodatabases?

I've been brushing up on relational database design theory, and I keep coming across primary keys (PKs) and foreign keys (FKs). PKs and FKs are said to be pillars of relational database design and ...
7
votes
3answers
9k views

Technical comparison of Oracle and PostgreSQL [closed]

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? ...
7
votes
2answers
3k views

where is the sequence in Oracle associated with the Objectid field in ArcGIS, and how to manage it?

I am working in ArcGIS 10.1 with tables from Oracle, now under control of SDE, after making use of the option: 'Register with Geodatabase'. All these tables have a column named 'Objectid' with an ...
7
votes
2answers
680 views

How are unsaved/temporary edits stored during versioned editing?

In ArcGIS Desktop, I can edit versioned, Oracle tables. I generally edit the default version, and I've registered the tables as versioned with the option to move edits to base. I do things like: ...
7
votes
4answers
1k views

Restricting values to domain codes (beyond attribute table)?

Geodatabase fields can be assigned domains. ArcGIS Desktop uses the domains as lookup tables (a.k.a. validation tables). When users edit data in the attribute table or attribute editing window, the ...
7
votes
1answer
480 views

What is the overall architecture of ArcSDE, and how does it fit into the enterprise?

I'm finding many gaps in my understanding of ArcSDE, particularly as it relates to Oracle. I just can't quite wrap my brain around the overall architecture of it, and how it fits into an enterprise. ...
7
votes
3answers
360 views

Changing a coded Domain to no codes

If we have coded domains in the geodatabase model, what are any disadvantages to changing the codes to the Description. For example: Existing Coded Domain: Code, Description 1, Single Family ...
7
votes
2answers
857 views

Get ArcMap to recognize ST_POINT (SDE.ST_GEOMETRY)

I have a sde.st_geometry line feature class called ROADS. I've created a view using a st_geometry function called st_startpoint which returns an st_point column. st_point is a subclass of st_geometry; ...
7
votes
2answers
2k views

QGIS DB Manager Import layer/file Oracle not working - Error 8 Loading of the layer failed

QGIS 2.12.0 - DB Manager 0.1.20 - Windows 7 - Oracle 11g 11.2.0.3.0 Import vector layer Shapefile as well as a layer (vector) and with every possible combinations of settings, the results are the ...
6
votes
4answers
1k views

Does the OBJECTID in an Oracle Geodatabase table have a primary key constraint, by default?

Tables that are created in Oracle using ArcGIS Desktop are given an OBJECTID field by default. The OBJECTID field is assigned a unique not-nullable index. Does the OBJECTID in an Oracle Geodatabase ...
6
votes
5answers
781 views

Versioned to unversioned: How to undo edits in an edit session on an unregistered table

I'm considering switching some of my tables in an Oracle enterprise geodatabase from versioned to unversioned. The pros of having unversioned tables would be: Simpler, traditional database design ...
6
votes
1answer
147 views

ArcPy UpdateCursor auto pausing after every 1000 records

I have an update cursor running that updates a field based on a lookup table (Python dictionary). The cursor completes fine, but seems to pause and hold after each 1000 records - I have a test in it ...
6
votes
2answers
1k views

Oracle / SDE: ST_GEOMETRY or SDE Compressed Binary

I read data from a SDE database (Oracle) directly. How do I know, which format is used to store the geometry data? Do I have to check the DataType for the geometry column or is this information ...
6
votes
1answer
2k views

ArcGIS Query Layer performance documentation or feedback

I first tried asking this question in the ArcGIS forums but as is common I got a total of 0 responses. I'm willing to accept this may be due to a lack of knowledge on the subject, but I'm optimistic. ...
6
votes
2answers
2k views

GIS Database Migration Project (Oracle to ArcGIS)

I have been tasked with converting an Oracle Database into an ESRI file geodatabase. The data represents a gas network. The client's Oracle database has over 400 tables, 120 of which are spatial. I'...
6
votes
2answers
684 views

ArcSDE locking Oracle schemas?

We changed a password on an Oracle schema, but apparently we have some rogue SDE clients - probably old ArcGIS map services on a dev machine somewhere - attempting to connect with the old password. ...
5
votes
4answers
2k views

Exporting data from Oracle to Esri File Geodatabase grid size error

My specs: ArcInfo 10.1, Oracle 11g I have a line dataset which is sat in Oracle 11g. I can read/query/symbolise this in ArcDesktop without any problems. I now want to export a selection into a file ...
5
votes
2answers
1k views

OGR to read from oracle, and then write a CSV

I need to read an Oracle (not spatial) table with OGR. I have no problem with ogrinfo. I use this command: ogrinfo -ro OCI:user/password -sql "select * from HR.EMPLOYEES" I have this kind of ...
5
votes
3answers
850 views

How not to Copy Features when too many would be output?

This question has already been posed to the ArcGIS Geoprocessing forum but I have had no responses there. I have a 3.5 million polygon layer (cadastre) stored in Oracle via ArcSDE. I use a polygon ...
5
votes
2answers
3k 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 ...
5
votes
3answers
789 views

Updates to ArcSDE via Oracle trigger

Is it possible and/or feasible for an Oracle trigger to periodically update ArcSDE via a REST geoprocessing service? Does anyone have any experience with such a thing? The reason for this is that I ...
5
votes
3answers
4k views

ST_Geometry vs SDE Binary: seeking recommendations, experiences

I've got some questions I've collected as we try to come to a decision about whether to use ST_Geometry or SDE native geometry for an Oracle/SDE datastore on a new project. The organization has quite ...
5
votes
1answer
235 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 ...
5
votes
1answer
6k views

ORA-28595: Extproc agent : Invalid DLL Path

I'm trying to create a table with spatial column in oracle and insert data into it. I'm using ArcSDE and Oracle. The version of Oracle is 11.2.0, the version of ArcSDE is 10.0. My create statement is:...
5
votes
2answers
1k views

How do you determine which dbclient connection property to use for an Oracle SQLWorkspace connection?

I have an Oracle11g database that I connect to via a SQL Workspace; however the actual dbclient string value that works differs depending on machine (and I'm guessing oracle client configuration). On ...
5
votes
1answer
473 views

How to Make a Thematic Map with ORACLE using MapXtreme?

I want to make a thematic map with Oracle source longitude and latitude values. I have made thematic maps with tab file source. Part of the code looks like this: MapInfo.Engine.Session.Current....
5
votes
1answer
290 views

ArcObjects edit/update ODBC Oracle table

Can an ODBC Oracle table attached by OLE within ArcMap be edited/updated by using ArcObjects? If so, what are the procedural steps for doing this? Are there code examples out there showing how to ...
4
votes
3answers
2k views

Converting double field to integer in database view so ArcMap query layer can use field as unique identifier

I have a field in a table that is a double data type, but the values are actually integers. The table is from third-party software, so I don't have control of the field data types. I'm attempting to ...
4
votes
2answers
1k views

Importing Feature Class to Oracle SDE Geodatabase Simplifies Features

I recently imported a feature class from a File Geodatabase to an Oracle SDE Geodatabase. The features of the two feature classes now look drastically different despite not having any edits made. ...
4
votes
2answers
449 views

Force Arcmap to respect primary key constraints/triggers

We have a feature class that has a primary key constraint(not OBJECTID) on it's database table. This field also has an auto incrementing trigger (BEFORE INSERT) When our users try to create/add ...
4
votes
1answer
379 views

Should slow refresh rate be expected while viewing 1000 points out of 100 million using ArcSDE/Oracle?

Is it normal to experience very slow refresh rate in ArcMap with 1000 points shown out of 100 million using ArcSDE/Oracle? I’am testing a setup with ArcSDE/Oracle database to contain geographical ...
4
votes
3answers
1k views

ArcMap query layer with Oracle Locator displaying no results

I have an Oracle 11g database setup with Oracle Locator. I have created a table with the this query: CREATE TABLE geotest (id NUMBER(38) NOT NULL, shape SDO_GEOMETRY); Then I inserted one point ...
4
votes
2answers
399 views

How is the st_length function stored in an Oracle geodatabase?

How is the st_length function stored in an Oracle geodatabase? Is it in a: PL/SQL function Separate .dll library Somewhere else? I've noticed that the sde.st_length function works, even when the ...
4
votes
2answers
304 views

Refresh linear referencing layer that's based on a database view, without closing ArcMap

Background: I have a linear referencing event layer that was created using the Make Route Event Layer geo-processing tool. The Input Route Features are in a standard feature class, but the Input ...
4
votes
1answer
1k views

Deleting Oracle SDE features classes properly

I have got a few feature classes in an SDE connection. This is the situation: a) They are listed in ArcCatalog (10.1), but the open fails. The message says: 'Error opening feature class, DBMS table ...
4
votes
1answer
316 views

Setting DATE as default column type for esriFieldTypeDate in ArcGIS Desktop?

If I use esriFieldTypeDate with ArcGIS 10.2 a DATE column is created in Oracle. If I use it in ArcGIS 10.6 a TIMESTAMP(6) is used Is there a way to set DATE as default column type for ...
4
votes
1answer
6k views

ArcSDE 10.2: How to enable and create Geodatabase in Oracle without ArcGIS Desktop

Since there is no Post Installation Wizard anymore in ArcSDE 10.2 - how can i enable und create a geodatabase in oracle without ArcGIS Desktop? We have only an EDN description for ArcGIS Server/SDE, ...
4
votes
2answers
575 views

Huge x,y,z dataset into oracle, possible?

I have 200 .xyz files containing 1500000 points each. Is this possible to import this dataset to oracle? It makes a total of 300.000.000 points!!! Background is I want to improve a FME script that ...
4
votes
3answers
3k 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 ...
4
votes
2answers
578 views

Calculating space feature class will use in ArcSDE?

Is it possible to get a good estimate on how much space a feature class will take once loaded into ArcSDE from how big they are in a FGDB? I have some feature classes in a FGDB, where some are a few ...
4
votes
2answers
1k 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 ...
4
votes
2answers
600 views

ArcObjects ISQLSyntax with Oracle DB esriSQL_DelimitedIdentifierPrefix issue

New to stack exchange, heading over from the esri forums, it is great! I am trying to produce a query that I can use across all workspaces, naturally using ISQLSyntax. The problem I'm having is that ...
4
votes
1answer
473 views

Identifying geometry storage type in geodatabase stored in Oracle?

How do I identify what geometry storage type is being used with a specific geodatabase stored in Oracle 9i via ArcSDE 9.3.1?
4
votes
1answer
295 views

Geokettle Data Input from Oracle Database

i just installed GeoKettle and am trying to do some first steps in this. Can anyone help me with the data input step to an Oracle DB? I tried the OGR Input: But i seem to be unable to find the right ...
4
votes
2answers
2k views

Failed to connect to the specified server, ArcGIS 10.1 connection using Oracle 11 g

I am trying to connect an Oracle 11g database to ArcGIS 10, but it's not working and gives the following error: "Failed to connect to the specified server. Operation Failed." While I am sure about ...

1
2 3 4 5
7