数据库常用数据字典

Static Data Dictionary Views

In Trusted Oracle Server, each of the dictionary tables and views contains a column that indicates the label of each row in the table or view. Trusted Oracle also provides some additional dictionary tables and views, and some Oracle8 dictionary tables and views contain columns that support compatibility with Trusted Oracle applications. See your Trusted Oracle documentation for more information about Trusted Oracle dictionary tables and views.

Data Dictionary Views

The following is an alphabetical reference of the data dictionary views accessible to all users of an Oracle Server. Most views can be accessed by any user with the CREATE_SESSION privilege.

The data dictionary views that begin with DBA_ are restricted. These views can be accessed only by users with the SELECT_ANY_TABLE privilege. This privilege is assigned to the DBA role when the system is initially installed.

ALL_ALL_TABLES

This view describes all of the tables (object tables and relational tables) accessible to the user.

ALL_INDEXES

This view contains descriptions of indexes on tables accessible to the user. To gather statistics for this view, use the SQL command ANALYZE. This view supports parallel partitioned index scans.

ALL_SEQUENCES

This view lists descriptions of sequences accessible to the user.

ALL_TABLES

This view contains descriptions of relational tables accessible to the user. To gather statistics for this view, use the SQL command ANALYZE.

ALL_TRIGGERS

This view lists trigger information for triggers owned by the user, triggers on tables owned by the user, or all triggers if the user has the CREATE ANY TRIGGER privilege.

ALL_USERS

This view contains information about all users of the database.

ALL_VIEWS

This view lists the text of views accessible to the user.

DBA_ALL_TABLES

This view displays descriptions of all tables (object tables and relational tables) in the database.

DBA_CONSTRAINTS

This view contains constraint definitions on all tables.

DBA_DATA_FILES

This view contains information about database files.

DBA_EXTENTS

This view lists the extents comprising all segments in the database.

DBA_FREE_SPACE

This view lists the free extents in all tablespaces.

DBA_INDEXES

This view contains descriptions for all indexes in the database. To gather statistics for this view, use the SQL command ANALYZE. This view supports parallel partitioned index scans.

DBA_JOBS

This view lists all jobs in the database.

DBA_ROLES

This view lists all roles that exist in the database.

DBA_ROLE_PRIVS

This view lists roles granted to users and roles.

DBA_ROLLBACK_SEGS

This view contains descriptions of rollback segments.

DBA_SEGMENTS

This view contains information about storage allocated for all database segments. DBA_TABLESPACES

This view contains descriptions of all tablespaces.