Oracle connector : system table/view used in query editor

Hi team,

We are currently experiencing a solution “Denodo” which exposes our business tables to Easymorph through an ODBC connector. Problem : our tables aren’t enough !
The query editor uses system tables/views as “all_objects”. Can you please tell us all the system tables/views used in the query editor ? Thanks !

Here is the error I get :
Error: Could not retrieve table names:
ERROR [ ] ERROR: View ‘all_objects’ not found
java.sql.SQLException: View ‘all_objects’ not found;
Error while executing the query

Hi Romain,

The following tables are used by the query editor: all_objects, all_tab_columns, and all_col_comments.

2 Likes