"tab"之间的区别表和Oracle中的all_tables [英] difference between "tab" table and all_tables in oracle

问题描述

使用(在oracle中)返回什么表

what tables are returned by using (in oracle)

select * from tab

和

select * from all_tables

我想知道两者之间的区别.

I would like to know the difference between two.

推荐答案

tab是一个不应使用的古代数据字典表.它的存在仅仅是为了向潜在的几十年前编写的脚本提供向后兼容性. tab不会随着新对象类型和新功能的添加而更新.

tab is an ancient data dictionary table that should never be used. It exists solely to provide backwards compatibility for scripts that were written potentially decades ago. tab does not get updated as new object types and new features get added.

• all_tables为您提供有关您有权访问的所有表的信息.
• tab为您提供有关您拥有的表，视图和同义词的信息(使其与诸如user_tables，user_synonyms和user_views之类的视图更相似).但是，它不知道诸如回收站之类的内容，因此tab将向您显示回收站中所有名称如BIN$+K4PlriXSGetpagyHCvBGA==$0的表.实际上，至少从Oracle 7天起添加的任何对象类型都可能会给tab之类的旧数据字典表造成问题.

• all_tables gives you information about all the tables that you have access to.
• tab gives you information about tables, views, and synonyms that you own (making it more similar to views like user_tables, user_synonyms, and user_views). It doesn't know about things like the recycle bin, though, so tab will show you all the tables with names like BIN$+K4PlriXSGetpagyHCvBGA==$0 that are in the recycle bin. Realistically, any object types that have been added at least since the Oracle 7 days are likely to create problems for legacy data dictionary tables like tab.

这篇关于"tab"之间的区别表和Oracle中的all_tables的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！