Oracle system tables


Below are some of the system table in Oracle (10gR2)

As I use the tables I will link useful and relevant SQL (Original)

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

Advertisements


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