oracle数据字典
oracle数据字典
以下表格中收集了oracle数据字典中几乎所有的视图或别名,至于每个视图或别名的字段请用‘describe’语句来查询。
命名说明:
oracle数据字典中,对象名称多数以"user.","all.","dba."为前缀"user."视图中记录通常记录执行查询的帐户所拥有的对象的信息,"all."视图中记录包括"user"记录和授权至public或用户的对象的信息,"dba."视图包含所有数据库对象,而不管其所有者。
使用举例:
select * from dba_data_files
查询表空间的信息(当前用户必须拥有dba角色)
select owner , object_name ,object_type from all_objects
查询某一用户下的所有表、过程、函数等信息
视图名 描述
all_catalog all tables, views, synonyms, sequences accessible to the user
all_col_comments comments on columns of accessible tables and views
all_col_grants_made grants on columns for which the user is owner or grantor
all_col_grants_recd grants on columns for which the user or public is the grantee
all_col_privs grants on columns for which the user is the grantor, grantee, owner, or an
enabled role or public is the grantee
all_col_privs_made grants on columns for which the user is owner or grantor
all_col_privs_recd grants on columns for which the user, public or enabled role is the grantee
all_constraints constraint definitions on accessible tables
all_cons_columns information about accessible columns in constraint definitions
all_db_links database links accessible to the user
all_def_audit_opts auditing options for newly created objects
Java Asp PHP .Net XML C/C++ CGI VB Jsp J2ee J2se J2me EJB Servlet Tomcat Resin Struts Weblogic Eclipse ANT GUI JMS Web servise IDEA Webphere Hibernate Spring Jboss Applet Swing Socket Javamail Perl Ajax P2P 安全 模式 框架 测试 开源 游戏
Windows XP Windows 2000 Windows 2003 Windows Me Windows 9.x Linux UNIX 注册表 操作系统 服务器 应用服务器