Unique ID issue loading attribute table of spatial views

bill_s — Mon, 02 Feb 2026 19:59:45 GMT

I wasn't sure if this question should be posted here or in the "Geodatabase Questions" section but the issue isn't really (imo) a database issue, but with how ArcGIS Pro displays the view.

So the problem is that the view(s) in question have duplicate OBJECTIDs, which is intended. I am getting the attribute tables of these views to load by generating a column of UIDs by using:

cast(rownum as number(38)) as MYUID

This is done in the first column in my views, which each looking something like:

create or replace view MYVIEW(MYUID, COL1, COL2,...) as select(cast(rownum as number(38)) as MYUID, VAR1, VAR2,...) ...;

The UIDs are always the first column, and I've tried using various alias for the UID column (such as OBJECTID, ROWNUMID, etc.), but it's a hit or miss whether or not ArcGIS Pro will auto-select it for use as the "default" UID field. If it does, the attribute table loads, if it doesn't, it fails to load and then I need to go in and manually set the UID field to it. This is fine, but creates extra work every time the view is loaded into a new project.

Is there a way to somehow get ArcGIS Pro to auto-select that first column as UID every time so whenever someone creates a new project using that view they won't get the error and then have to manually go set UID?

Re: Unique ID issue loading attribute table of spatial views

VenkataKondepati — Mon, 02 Feb 2026 21:10:56 GMT

I think you should Register with Geo-database to solve this problem permanently.
Register With Geodatabase (Data Management)—ArcGIS Pro | Documentation

topic Re: Unique ID issue loading attribute table of spatial views in ArcGIS Pro Questions

Unique ID issue loading attribute table of spatial views

Re: Unique ID issue loading attribute table of spatial views