topic Re: spatial view from 03 tables in Data Management Questions https://community.esri.com/t5/data-management-questions/spatial-view-from-03-tables/m-p/619503#M34989 <HTML><HEAD></HEAD><BODY><P>I do not know what an "03 Oracle table" is, but when you register a table with the geodatabase it does ask for the following:</P><P></P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P><SPAN class="" style="color: #4d4d4d; background-color: #fefefe;">The table or view must contain a not null, unique, integer field to be used as an<SPAN>&nbsp;</SPAN><A href="https://desktop.arcgis.com/en/arcmap/latest/manage-data/geodatabases/arcgis-field-data-types.htm#GUID-3C98DA8B-8D97-4E9F-AA34-F69C737A9871" style="color: #007ac2; text-decoration: none;">ObjectID field</A>.</SPAN></P><P style="color: #4d4d4d; background-color: #fefefe; font-size: 14px; margin-top: 0em; margin-bottom: 1.71429em;">If you register a table, you can specify an existing field for the ObjectID. If you do not specify an existing field for the ObjectID when registering a table, ArcGIS will add an ObjectID field to the table.</P></BLOCKQUOTE><P><A class="link-titled" href="https://desktop.arcgis.com/en/arcmap/latest/manage-data/geodatabases/registering-a-table-with-the-geodatabase.htm" title="https://desktop.arcgis.com/en/arcmap/latest/manage-data/geodatabases/registering-a-table-with-the-geodatabase.htm">Register a table or view with the geodatabase—ArcGIS Help | Documentation</A>&nbsp;</P><P></P><P>Hope this helps.</P></BODY></HTML> Mon, 11 May 2020 11:24:45 GMT George_Thompson 2020-05-11T11:24:45Z spatial view from 03 tables https://community.esri.com/t5/data-management-questions/spatial-view-from-03-tables/m-p/619502#M34988 <HTML><HEAD></HEAD><BODY><P>I am trying to register a spatial view from 03 oracle tables. Is it possible?<BR />These tables have to register (have ObjectID), but when trying to register the view it asks me for an ObjectID,</P></BODY></HTML> Sun, 10 May 2020 17:03:50 GMT https://community.esri.com/t5/data-management-questions/spatial-view-from-03-tables/m-p/619502#M34988 PamelaLandy 2020-05-10T17:03:50Z Re: spatial view from 03 tables https://community.esri.com/t5/data-management-questions/spatial-view-from-03-tables/m-p/619503#M34989 <HTML><HEAD></HEAD><BODY><P>I do not know what an "03 Oracle table" is, but when you register a table with the geodatabase it does ask for the following:</P><P></P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P><SPAN class="" style="color: #4d4d4d; background-color: #fefefe;">The table or view must contain a not null, unique, integer field to be used as an<SPAN>&nbsp;</SPAN><A href="https://desktop.arcgis.com/en/arcmap/latest/manage-data/geodatabases/arcgis-field-data-types.htm#GUID-3C98DA8B-8D97-4E9F-AA34-F69C737A9871" style="color: #007ac2; text-decoration: none;">ObjectID field</A>.</SPAN></P><P style="color: #4d4d4d; background-color: #fefefe; font-size: 14px; margin-top: 0em; margin-bottom: 1.71429em;">If you register a table, you can specify an existing field for the ObjectID. If you do not specify an existing field for the ObjectID when registering a table, ArcGIS will add an ObjectID field to the table.</P></BLOCKQUOTE><P><A class="link-titled" href="https://desktop.arcgis.com/en/arcmap/latest/manage-data/geodatabases/registering-a-table-with-the-geodatabase.htm" title="https://desktop.arcgis.com/en/arcmap/latest/manage-data/geodatabases/registering-a-table-with-the-geodatabase.htm">Register a table or view with the geodatabase—ArcGIS Help | Documentation</A>&nbsp;</P><P></P><P>Hope this helps.</P></BODY></HTML> Mon, 11 May 2020 11:24:45 GMT https://community.esri.com/t5/data-management-questions/spatial-view-from-03-tables/m-p/619503#M34989 George_Thompson 2020-05-11T11:24:45Z