ArcGIS Pro 3.3.0; Oracle 19c database (non-GDB); SDO_GEOMETRY:
There are cases where there are issues in Pro, and the Make Query Table tool is an effective workaround:
The reason Make Query Table is an effective workaround is that Query Table seems to use a different mechanism compared to normal layers and table views. For example, a Query Table has a SQL expression, but it isn't a definition query; it appears to be hidden/embedded within the layer.
As a result of that different mechanism, Query Tables work in scenarios where other feature layers and table views don't.
So, it is a very handy tool, but it doesn't support enterprise database tables (non-GDB).
Make Query Table (Data Management)
This tool accepts data from a geodatabase or an OLE DB connection.
ERROR 000837: The workspace is not the correct workspace type.
Idea:
Could Make Query Table be enhanced so that it supports database tables (non-GDB)?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.