Oracle System Tables


Below is an alphabetical listing of the Oracle system tables that are commonly used.

System Table

Description

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 init.ora

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

TABLE_PRIVILEGE_MAP

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


 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s