请问Oracle的CAT、TAB表与user_tables表有什么区别么?好像TAB表的数据要多于user_tables表的数据,谢谢!
------解决方案--------------------
select tname from tab where TABTYPE='TABLE';与user_tables表的数据是等价的。 TABTYPE不一定只是表,也有可能是view等,所以你要选出来TABTYPE='TABLE'的所有表
------解决方案--------------------
sys@ORCL> desc cat
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
TABLE_NAME NOT NULL VARCHAR2(30)
TABLE_TYPE VARCHAR2(11)
sys@ORCL> desc tab
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
TNAME NOT NULL VARCHAR2(30)
TABTYPE VARCHAR2(7)
CLUSTERID NUMBER
sys@ORCL> select * from dict where table_name='CAT';
TABLE_NAME COMMENTS
---------- -----------------------------------
CAT Synonym for USER_CATALOG
sys@ORCL> select * from dict where table_name='USER_CATALOG';
TABLE_NAME COMMENTS