오라클 시스템 테이블

SystemTable

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

출처 : http://www.techonthenet.com/oracle/sys_tables/

You may also like...

답글 남기기

이메일 주소는 공개되지 않습니다. 필수 항목은 *(으)로 표시합니다