Hi,
Question about registering a view in an enterprise GDB: how is it possible to have a NOT NULLABLE ObjectID field to register a view into an Enterprise GDB?
Usually, a view will inherit settings from the base table, in the case of a table with an ObjectID field NOT NULLABLE, the ObjectID field in the view should/will be NOT NULLABLE.
On the other hand, if the view is built-up with a third-party SQL client, with an ObjectID built from a CAST() SQL statment, how to specify that this ObjectID field will be NOT NULLABLE?
I need this NOT NULLABLE ObjectID field in my view in order to register the view with an Enterprise GDB, as explained here:
https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/register-a-table-or-view-wi...
So far, I managed to built an ObjectID field as an Integer in Oracle, recognized as Long in ESRI ArcGIS. But I still get an error when trying to register the view in Enterprise GDB... and I suspect with NOT NULLABLE ObjectID field in my view...
Any help really appreciated.