you can easily use these global views to get specific oracle system information: select * from [VIEW name] ALL_ALL_TABLES: shows all tables even with DBA system tables USER_ALL_TABLES : shows all tables available to user DBA_ALL_TABLES : all dba objects and system tables The view USER_TAB_COLUMNS lists all the columns detail information on the all […]