数据库对象、表空间、表、视图、索引、同义词序列等的字典

----对象数据字典：

---1查看相关字典的源字典：

select * from dict;

 

---2查看所有对象objects：

sys@PROD>select * from all_objects;

sys@PROD>select * from dba_objects;

sys@PROD>select * from user_objects;

#查看各个用户的所有对象。

---3查看tab的信息:

susu@PROD>select * from tab;

#查看各个用户的表与视图对象。

 

---4查看表对象Tables：

sys@PROD>select * from all_tables;

sys@PROD>select * from all_all_tables;

#两个字典查询的信息差不多相同。

 

sys@PROD>select * from dba_tables;

sys@PROD>select * from dba_all_tables;

 

sys@PROD>select * from user_tables;

sys@PROD>select * from user_all_tables;

 

---5查看索引Indexes:

sys@PROD>select * from all_indexes;

sys@PROD>select * from dba_indexes;

sys@PROD>select * from user_indexes;

 

---6查看字段cols:

sys@PROD>select * from dba_tab_cols;

sys@PROD>select * from all_tab_cols;

sys@PROD>select * from user_tab_cols;

 

---7查看表空间tablespace：

sys@PROD>select * from dba_tablespaces;

sys@PROD>select * from dba_tablespace_groups;

sys@PROD>select * from user_tablespaces;

sys@PROD>select * from v$tablespace;

---8查看视图views：

sys@PROD>select * from all_views;

sys@PROD>select * from dba_views;

sys@PROD>select * from user_views;

---9查看序列sequences的信息：

Select * from dba_sequences;

Select * from all_sequences;

Select * from user_sequences;

 

---10查看同义词synonyms的信息：

Select * from dba_synonyms;

Select * from all_synonyms;

Select * from user_synonyms;

---11查看数据库的database links的信息：

Select * from dba_db_links;

sys@PROD>desc dba_db_links

 Name                                      Null?    Type

 ----------------------------------------- -------- ----------------------------

 OWNER                                     NOT NULL VARCHAR2(30)

 DB_LINK                                   NOT NULL VARCHAR2(128)

 USERNAME                                           VARCHAR2(30)

 HOST                                               VARCHAR2(2000)

 CREATED                                   NOT NULL DATE

--当然还有很多的视图在日常数据库管理中运用到的，其中还包括过程、函数、包与触发器的视图 字典。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31392094/viewspace-2131194/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31392094/viewspace-2131194/