dba_tables,dba_all_tables,user_tables,all_tables有什麼區別

liuhaimiao發表於2014-09-28
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.

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/223653/viewspace-1283237/,如需轉載,請註明出處,否則將追究法律責任。

相關文章