oracle常用表

Oracle常用系统信息表

系统表

描述

ALL_ARGUMENTS

Arguments in object accessible to the user

用户可访问的对象参数

ALL_CATALOG

All tables, views, synonyms, sequences accessible to the user

用户可访问的所有表、视图、同义词、序列

ALL_COL_COMMENTS

Comments on columns of accessible tables and views

可访问的表和视图的列的注释

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_ERRORS

Current errors on stored objects that user is allowed to create

允许用户创建的存储对象的当前错误信息

ALL_INDEXES

Descriptions of indexes on tables accessible to the user

用户可访问的表上创建的索引描述

ALL_IND_COLUMNS

COLUMNs comprising INDEXes on accessible TABLES

可访问的表上的索引的列

ALL_LOBS

Description of LOBs contained in tables accessible to the user

用户可访问的表包含的大型数据对象的描述

ALL_OBJECTS

Objects accessible to the user

用户可访问的对象

ALL_OBJECT_TABLES

Description of all object tables accessible to the user

用户可访问的对象的描述

ALL_SEQUENCES

Description of SEQUENCEs accessible to the user

用户可访问的序列的描述

ALL_SNAPSHOTS

Snapshots the user can access

用户可访问的快照

ALL_SOURCE

Current source on stored objects that user is allowed to create

允许用户创建的当前存储对象的原始资料

ALL_SYNONYMS

All synonyms accessible to the user

用户可访问的所有同义词

ALL_TABLES

Description of relational tables accessible to the user

用户可访问的所有关系表的描述

ALL_TAB_COLUMNS

Columns of user's tables, views and clusters

与用户有关的表、视图和簇的列

ALL_TAB_COL_STATISTICS

Columns of user's tables, views and clusters

与用户有关的表、视图和簇的列的统计信息

ALL_TAB_COMMENTS

Comments on tables and views accessible to the user

用户可访问的表和视图的注释

ALL_TRIGGERS

Triggers accessible to the current user

当前用户可访问的触发器

ALL_TRIGGER_COLS

Column usage in user's triggers or in triggers on user's tables

用户的触发器或用户表上的触发器的列的用途

ALL_TYPES

Description of types accessible to the user

用户可访问的类型描述

ALL_UPDATABLE_COLUMNS

Description of all updatable columns

所有可更新列的描述

ALL_USERS

Information about all users of the database

与数据库相关的所有用户信息

ALL_VIEWS

Description of views accessible to the user

用户可访问的视图的描述

DATABASE_COMPATIBLE_LEVEL

Database compatible parameter set via

通过设置的数据库兼容参数

DBA_DB_LINKS

All database links in the database

数据库中所有的数据库链接

DBA_ERRORS

Current errors on all stored objects in the database

数据库中所有对象当前的错误信息

DBA_OBJECTS

All objects in the database

数据库中所有的对象

DBA_ROLES

All Roles which exist in the database

数据库中存在的所有角色

DBA_ROLE_PRIVS

Roles granted to users and roles

授予用户和角色权限的角色

DBA_SOURCE

Source of all stored objects in the database

数据库中所有的存储对象的原始信息

DBA_TABLESPACES

Description of all tablespaces

所有表空间的描述

DBA_TAB_PRIVS

All grants on objects in the database

数据库中所有对象的授权

DBA_TRIGGERS

All triggers in the database

数据库中所有的触发器

DBA_TS_QUOTAS

Tablespace quotas for all users

所有用户的表空间限额

DBA_USERS

Information about all users of the database

数据库中所有用户的相关信息

DBA_VIEWS

Description of all views in the database

数据库中所有视图的描述

DICTIONARY

Description of data dictionary tables and views

数据字典的表和视图的描述

DICT_COLUMNS

Description of columns in data dictionary tables and views

数据字典的表和视图的列的描述

GLOBAL_NAME

Global database name

全局数据库名

NLS_DATABASE_PARAMETERS

Permanent NLS parameters of the database

数据库中永久国家语言参数

NLS_INSTANCE_PARAMETERS

NLS parameters of the instance

实例的国家语言参数

NLS_SESSION_PARAMETERS

NLS parameters of the user session

会话的国家语言参数

PRODUCT_COMPONENT_VERSION

Version and status information for component products

产品的版本和状态信息

ROLE_TAB_PRIVS

Table privileges granted to roles

授权给角色的表权限

SESSION_PRIVS

Privileges which the user currently has set

用户当前被设定的权限

SESSION_ROLES

Roles which the user currently has enabled

用户当前有效的角色

SYSTEM_PRIVILEGE_MAP

Description table for privilege type codes. Maps privilege type numbers to type names

系统权限类型编码表描述。权限类型号码到类型名称的映射。

TABLE_PRIVILEGES

Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC

is the grantee

当用户是授权者、被授权者、所有者或者一个有效的角色或者PUBLIC是授权者时的对象授权

TABLE_PRIVILEGE_MAP

Description table for privilege (auditing option) type codes. Maps privilege (auditing option)

type numbers to type names

表权限类型编码表描述。权限类型号码到类型名称的映射。

本文来自CSDN博客，转载请/rootea/archive/2009/03/04/

标明出处：