----对象数据字典:
---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/