日期:2014-05-16  浏览次数:20415 次

oracle_杂乱
DBA_TABLES >= ALL_TABLES >= USER_TABLES

oracle官方文档的说明
1.DBA_ALL_TABLES describes all object tables and relational tables in the database. Its columns are the same as those in ALL_ALL_TABLES.

2.ALL_ALL_TABLES describes the object tables and relational tables accessible to the current user.

3.USER_ALL_TABLES describes the object tables and relational tables owned by the current user. Its columns (except for OWNER) are the same as those in ALL_ALL_TABLES.