Title: Using EOModeler with Oracle - Specifying Query for Tables
Entry Number: Last Updated: 31 Mar 1995 Document Revision:
Keywords: EOModeler, Oracle
Q: I want to see all the tables I have access to, but EOModeler doesn't list them all. Why?
A: By default, the Oracle7 adaptor will only show the tables that you own, not all of the tables that you have access to. So, in order to get all the tables that you own, you can specify the following dwrite:
dwrite Oracle7Adaptor OracleTableNamesSQL "select object_name from user_objects where object_type in ('TABLE', 'VIEW', 'SYNONYM')"