Building Oracle views that don't request Unique ID in ArcMap

Question

Hello,

I have been building views in our Oracle database that assist GIS editors with various aspects of their work.  After I create a view in Oracle SQL Developer, editors will add it to their ArcMap sessions as needed.  The annoying part is whenever they add the view ArcMap pops up a window asking them to pick an unique ID.  Often they don't know which field to pick.  How can I build views that have the unique ID predefined by me so GIS users don't have to get this window every time?

Thank you,

Andrew

AsrujitSengupta · Answer

You can use SDE Command Line tools for the 10.3 gdb, that is what the link mentions for now. However, we wouldn't recommend this. This has been working and so is just a suggestion\possibility.

AndrewRudin · Answer

Thanks.  I haven't used the command line tools since so much is in ArcToolbox now. We are upgrading to 10.3 SDE and desktop client by the end of the year.  With the command line tools going away I'm guessing this trick won't be a possibility after that.

AsrujitSengupta · Answer

If you prefer, you can use SDE Command line 10.2.2 to register the View with SDE OR directly use the command line tools to create the View. This will not prompt for the Unique Identifier in ArcMap.

44300 - Can ArcSDE command line tools be used against 10.3 and newer geodatabases?