0
votes
0answers
37 views

Changing default precision and scale of number fields in ArcSDE geodatabase table?

After I change the precision and scale for my short, long, float, and double field types when creating a table in ArcMap SDE geodatabase, ArcMap will reset my precision and scale to default values. ...
0
votes
1answer
61 views

Copy features between file geodatabase and ArcSde by using ArcObjects

I want to transfer all contents of a table from file geodatabase (*.gdb) to a table in ArcSde. In fact the data is meant to be replaced, so I need also to clear the table in ArcSde. Both tables have ...
2
votes
1answer
61 views

What's the proper way of deleting versioned data from an SDE geodatabase?

I haven't really read this anywhere. What is the proper way of deleting versioned data from an SDE geodatabase to make sure nothing is left behind in the A & D tables? Do I need to unversion the ...
3
votes
0answers
137 views

Geodatabase Connection to Oracle Active Data Guard Standby

Thank you in advance for any help you can provide. ENVIRONMENT Database Server: Oracle 11.2.0.2.0 Single-Instance Database on Windows Server 2003 R2 Enterprise 64-bit Oracle Active Data Guard for ...
0
votes
1answer
112 views

How to fix spatial reference error on CopyFeatures ArcGIS tool?

When I run the CopyFeatures tool to copy features from an ArcSDE geodatabase to another empty ArcSDE geodatabase (no features, no tables), I get the following result: The error message is about the ...
2
votes
1answer
91 views

How to register table with geodatabase with a command line?

Is there a way to register with geodatabase a table stored in an Oracle 11g database, without using ArcMap or Python script? I'd like to do it with a command line like when registering with ArcSDE ...
1
vote
1answer
284 views

ArcGIS: Versioning, Post & Reconcile, Compressing, and Lost in Space

Alright guys, I'm in a bad way here. Here is the short version, and I'll post the long detailed version below. I'm needing to figure out an easier way to post changes to the data on our SDE ...
8
votes
1answer
161 views

How to perform Full Text Search of Esri geodatabase?

How would you go about searching the contents of features, the values in the attribute columns, in an Esri geodatabase? (preference for file-gdb, but SDE would be useful too.) I can envisage workflow ...
0
votes
0answers
68 views

SDE Feature Class - Coded Values and Existing Data

I have a SDE Feature class with ~2500 features. Of course all of these have several attributes. I want to use this feature class for a Feature Service, so users are able to add new feature the the ...
1
vote
2answers
118 views

Update license for enterprise geodatabase with GP/Python?

I am attaching dozens of database files to a SQL Server instance and then I have to run sdesetup command to update the geodatabase license by pointing to my ArcGIS Server license. I am trying to find ...
2
votes
2answers
360 views

How to copy selected features from one sde to another using ArcObjects?

Assuming I have two SDEs or other datasources with the same datamodel. One contains features the other one is empty. In ArcMap I have layers from both datasources in my table of contents. Now I would ...
0
votes
1answer
346 views

How to resolve ArcGIS for Desktop Error (SDE has lost its connection with underlying DBMS[ORA-03114:not connected ORACLE])? [duplicate]

How to resolve this issue when user leaves the system idle for one hour and again trying to connect Database, It encounters the Connection error message and then user should close the ArcGIS and ...
1
vote
0answers
68 views

Is there tutorial available for PostGIS setup in ArcSDE 10.1 geodatabase on Linux?

Is there any tutorial for Set up PostGIS in an ArcSDE 10.1 geodatabase on Linux? There is one in tutorial arcgis 9 for ArcGIS version 9, but I couldn't find any for ArcGIS 10.1.
3
votes
1answer
202 views

Triggers for delta tables

I have been facing an issue to capture the delta updates on SDE. We have written triggers on A and D tables to capture the delta updates(to capture the version name based on state id's), however I ...
1
vote
0answers
99 views

ESRI Versioning: A table doesn't match base table schema

ArcGIS 10.1 sp1 with Oracle 11g I've got a versioned feature class that I have discovered has a base table with a different schema than the corresponding A table. (A + registration_id from ...
0
votes
0answers
78 views

Error when deleting field in arcgis: “Table contails a column type not allowed in versioned views”

Something messy :) happened to my geodatabase. When I'm trying to delete a field in ArcMap I get this message: * "Failed to delete the selected field. Table contains a column type not allowed ...
1
vote
2answers
901 views

ArcSDE 10: How to read/write to Oracle with ST_GEOMETRY using Java

I found the following in the deprecation plan of ArcGIS 10.2: ArcGIS 10.2 will be the last major release to support the ArcSDE SDK with the ArcSDE C and Java APIs. Today many other options are ...
3
votes
1answer
2k 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, ...
6
votes
1answer
354 views

Is this possible with ArcGIS using replication?

I work for a telecom company dealing with fiber management. We have a sister company south of us who we share some fiber and fiber equipment with. Both of us will be using ArcSDE databases. We want ...
1
vote
0answers
189 views

Replicas: Synchronize changes for individual feature class (not entire replica)

I have two ArcSDE databases, running with a two-way replica.One serves our interactive mapping website which gives certain users the ability to update, add points, edit attributes, etc. Then we have ...
0
votes
0answers
78 views

New/Imported Raster dataset given dbo schema in SDE geodatabase

I have an Esri ArcSDE geodatabase (10.1) on SQL Server with a custom database scheme called "GC" which is used to host all the project datasets. In ArcCatalog, a SDE connection file was created with ...
2
votes
1answer
208 views

How can you tell if a RDBMS is an ArcSDE Geodatabase?

I want to know if there is any way I can query the RDBMS to determine whether it is an ArcSDE Geodatabase, or if I have to do it through ArcObjects. I am wondering if it would be enough to check if ...
2
votes
1answer
119 views

Renaming shapefiles with prefix while running arcpy.FeatureClassToGeodatabase?

I'm fairly new to the arcpy world. I am trying to create a script in 10.0 that will load a dataset (file geodatabase) into ArcSDE and rename the feature classes with a prefix, i.e. San_Diego_Bay -> ...
1
vote
1answer
167 views

How to Change the schema of SDE dataset in Connected environment

We continuously use to receive changes in Schema ( field +/-, domain changes etc ) for our Utility dataset.. Since we have swicthed to a multiuser Geodatabase ( ArcSDE on Oracle ) , we would like to ...
4
votes
1answer
151 views

Difference between registering with ArcSDE and registering with Geodatabase?

As I understand it : Registering with ArcSDE: gives the possibility to ArcGIS to recognize spatial data stored in a database Registering with Geodatabase: makes it possible for data to participate ...
3
votes
2answers
78 views

Can feature classes have the same name in two different feature datasets?

I have an SDE Database called "Vector" which contains many feature datasets eg. Region_1, Region_2 etc. I have to reproject the feature classes inside these datasets. Instead of creating a new ...
5
votes
2answers
260 views

Why shouldn't data be loaded into an enterprise geodatabase logged in with sde user?

I've read somewhere that it is not good practice to load data into an enterprise geodatabase using the sde user. I was wondering what the reason for this is? Thanks.
1
vote
1answer
75 views

Migrating Lines to ArcGIS polyline

I'm trying to import geometry lines from Oracle Spatial database to ArcGIS enterprise geodatabase. and some data will cause the error. Its says not enough points for feature class, but when I look ...
-1
votes
0answers
37 views

Oracle Feature Class Couldn't Displayed

I got problem on displaying feature class in Oracle, which successfully imported from file geodatabase using Append (Data Management) Tools, my experiment on copying it to Postgre no problem on ...
1
vote
0answers
191 views

ArcGIS 10.1 SDE database schema other than SDE or DBO

Just wondering if it's possible to apply a schema other than SDE or DBO to SDE feature or raster tables stored in an enterprise database on MS SQL Server 2008 R2. I have got a new customise schema ...
1
vote
1answer
264 views

Importing data from Oracle Data Pump into empty Oracle ArcSDE Geodatabase?

I have an ArcSDE Geodatabase that contains empty layers created using ArcCatalog. I would like to import data into those layers from a Data Pump of an Oracle database that has the same structure as ...
3
votes
1answer
174 views

Synchronizing Changes From File Geodatabase to SDE Geodatabase

I have an SDE geodatabase that has a one way replication to a file geodatabase, where I will make edits to the feature classes offline somewhere. I know that this scenario doesn't support one-way or ...
6
votes
1answer
171 views

When to use multiple geodatabases?

I'm working on a project involving one database , but the customer's needs have evolved, so he needs to manage multiple projects. I tried to work with adding an id for each project, which gave me more ...
2
votes
0answers
293 views

Can I use an Update cursor with a versioned feature class which has attachments in ArcObjects .NET

I have a problem with my code (C# ArcObjects 10.1). We are trying to update and insert 10 - 15 rows at a time into a feature class hosted in ArcSDE 10.1 on SQL Server 2008 R2. We have a feature class ...
6
votes
2answers
232 views

How to undo ArcGIS “Move Edits to Base” mistake?

I'm trying to help a client who mistakenly checked the "Move Edits to Base" option when versioning a feature class in ArcGIS. They would now like to fix this mistake. However, they don't want to ...
0
votes
1answer
93 views

Creating “Empty” version of ArcSDE geodatabase?

Is it possible to create an "Empty" version of an ArcSDE geodatabase? I have a large default ArcSDE geodatabase that I would like to create an empty version for a new project. By "Empty" version I ...
3
votes
2answers
211 views

Running Regular Queries Through ArcSDE

Working on an .net arcobjects app that's connecting to a Geodatabase (Oracle) through ArcSDE. I make a bunch of edits inside a EditSession but the data I am touching have a bunch of foreign Key ...
3
votes
0answers
830 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 ...
5
votes
0answers
171 views

Why do file geodatabase and SDE readers produce different fme_geometry types?

I have one very simple workbench that I am running against both SDE (9.3) and FGDB (10.0) sources. I noticed two different fme_geometry values for same type of objects. For the first one, i.e SDE ...
7
votes
1answer
271 views

How to apply schema changes on Esri geodatabase two-way replica set?

I have an Esri geodatabase two-way replica set. I need to update the schema on both databases in the replica set. Esri describes doing this using ArcGIS schema tools (compare/export/import replica ...
2
votes
0answers
283 views

Create ESRI ArcSDE Connection File (.sde) using Python/ArcPy at the ArcView license level?

Is there an alternative way to create ArcSDE connections in ArcGIS 10.0 using Python at the ArcView license level? I need to create 4 separate connection files for a MXD SDE data source re-point tool. ...
3
votes
0answers
92 views

How to split Relationship Class privileges between different users while maintaining referential integrity?

I am using a relationship class to maintain a one-to-many relationship between material sites (under Engineering's purview) and the material sites' sample status and content (under Materials' ...
1
vote
3answers
564 views

Convert Oracle schema to GeoDatabase using Direct Connect only

Either this is a gap in the documentation or I'm really missing something! I know that I can direct connect to an SDE GeoDatabase without needing ArcSDE to be installed on the database server, but I ...
3
votes
1answer
1k views

Where is connection file used to connect ArcMap to ArcSDE?

In ArcMap 10.0, how do I find where the connection file is that is being used to connect to ArcSDE 10 on Sql Server 2008? Some non administrative users are hooking up to SDE as the user 'sde' with db ...
3
votes
1answer
244 views

Using CAST function in ArcMap 10 with ArcSDE?

I would like to use the CAST function in the definition query property of a layer and/or in the label class sql query window. This was the most promising link that I've found, including the two links ...
1
vote
0answers
417 views

SQL sub query syntax does not work on versioned tables without base option- Modified

My original question asked why the where clause below, which includes a sub query, would not work on an SDE database but the same query against a file geodatabase would work. I had thought the ...
3
votes
1answer
293 views

Deleted features not synchronizing in one-way (ArcSDE to File Geodatabase) geodatabase replication?

I am testing three one way (ArcSDE 10 -> File Geodatabase) replicas. Each replica is derived from a layer created by selection by location from a citywide road dataset, so that each of the three ...
3
votes
1answer
956 views

Error importing XML workspace document to file geodatabase

Ok so I have a large SDE geodatabase that I exported to an XML Workspace Document. I tried to importing it again into a file geodatabase to test if the export worked correctly and got the following ...
2
votes
1answer
135 views

Finding the Default version in a large linage tree

I have a very large versioning linage tree. I am using the arcGIS 10.0 GDBT tool. How can I find the node with the default version?
2
votes
0answers
405 views

How to get WKT from SHAPE column in the ArcSDE geodatabase?

I have an ArcSDE geodatabase running on top of SQL Server 2008. A table for a feature layer was added from ArcCatalog. The SHAPE column is a type of int which was automatically converted from ...