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


 

Iklan

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout /  Ubah )

Foto Google+

You are commenting using your Google+ account. Logout /  Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout /  Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout /  Ubah )

Connecting to %s