----对象数据字典：

---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