Community
Select to view content in your preferred language

Has anybody registered existing Oracle tables with ArcSDE? How to handle UID.

850
1
12-22-2010 06:01 AM
JasonThiel
by
Emerging Contributor
‎12-22-2010 06:01 AM
We are new to ESRI and have existing database tables.  We have been attempting, with some degree of success, to register them using sdelayer command line utility.

We have found that many of our tables do not have the required field for the UID that is number(38), unique, and not null.  some of our tables have a similar field of type number.  We know that they are not registering properly if the type is number.

We are considering adding a new field "esri_uid" to each table that we wish to register with the SDE. 
Has anybody else done this?  Any suggestions and/or alternate solutions?

Thanks in advance.
0 Kudos
1 Reply
JasonThiel
by
Emerging Contributor
‎12-23-2010 08:44 AM
The word that i got from tech support is that we should add a new "esri_uid" column to each table that we wish to register.  has to be Number(38), not null, unique.

The Number(38) is key.  Number won't work.  Number(38) will.
0 Kudos