dba_tables，dba_all_tables,user_tables,all_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.
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.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/223653/viewspace-1283237/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
oracle系统视图作用大全
下一篇：
ORACLE目录
请登录后发表评论
登录
全部评论
