user_tables、all_tables、dba_tables的有什么区别？

unique_man

RT。
这三个视图有什么区别呢？

为什么我创建的表有的在user_tables中能查到，有的又查不到呢？靠什么建立的这几个视图呢？

ziggler

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.
dba_tables，dba_all_tables,user_tables,all_tables有什么区别 - Oracle数据库管理 - ITPUB论坛 - 澳信传媒旗下专业技术社区 (28 August 2009)
http://www.itpub.net/thread-962151-1-1.html

山野村夫

ALL_TABLES describes the relational tables accessible to the current user. To gather statistics for this view, use the ANALYZE SQL statement.

DBA_TABLES describes all relational tables in the database.

USER_TABLES describes the relational tables owned by the current user. This view does not display the OWNER column.