컴퓨터활용/오라클

ORACLE DATA DICTIONARY TABLE

멜번초이 2003. 10. 12. 00:07
Data Dictionary Views Available Through Heterogeneous Services
This appendix lists the data dictionary views that are supported through heterogeneous services mapping:

ALL_CATALOG

ALL_COL_COMMENTS

ALL_COL_PRIVS

ALL_COL_PRIVS_MADE

ALL_COL_PRIVS_RECD

ALL_CONSTRAINTS

ALL_CONS_COLUMNS

ALL_DB_LINKS

ALL_DEF_AUDIT_OPTS

ALL_DEPENDENCIES

ALL_ERRORS

ALL_INDEXES

ALL_IND_COLUMNS

ALL_OBJECTS

ALL_SEQUENCES

ALL_SNAPSHOTS

ALL_SOURCE

ALL_SYNONYMS

ALL_TABLES

ALL_TAB_COLUMNS

ALL_TAB_COMMENTS

ALL_TAB_PRIVS

ALL_TAB_PRIVS_MADE

ALL_TAB_PRIVS_RECD

ALL_TRIGGERS

ALL_USERS

ALL_VIEWS

AUDIT_ACTIONS

COLUMN_PRIVILEGES

DBA_CATALOG

DBA_COL_COMMENTS

DBA_COL_PRIVS

DBA_OBJECTS

DBA_ROLES

DBA_ROLE_PRIVS

DBA_SYS_PRIVS

DBA_TABLES

DBA_TAB_COLUMNS

DBA_TAB_COMMENTS

DBA_TAB_PRIVS

DBA_USERS

DICTIONARY

DICT_COLUMNS

DUAL

INDEX_STATS

PRODUCT_USER_PROFILE

RESOURCE_COST

ROLE_ROLE_PRIVS

ROLE_SYS_PRIVS

ROLE_TAB_PRIVS

SESSION_PRIVS

SESSION_ROLES

TABLE_PRIVILEGES

USER_AUDIT_OBJECT

USER_AUDIT_SESSION

USER_AUDIT_STATEMENT

USER_AUDIT_TRAIL

USER_CATALOG

USER_CLUSTERS

USER_CLU_COLUMNS

USER_COL_COMMENTS

USER_COL_PRIVS

USER_COL_PRIVS_MADE

USER_COL_PRIVS_RECD

USER_CONSTRAINTS

USER_CONS_COLUMNS

USER_DB_LINKS

USER_DEPENDENCIES

USER_ERRORS

USER_EXTENTS

USER_FREE_SPACE

USER_INDEXES

USER_IND_COLUMNS

USER_OBJECTS

USER_OBJ_AUDIT_OPTS

USER_RESOURCE_LIMITS

USER_ROLE_PRIVS

USER_SEGMENTS

USER_SEQUENCES

USER_SNAPSHOT_LOGS

USER_SOURCE

USER_SYNONYMS

USER_SYS_PRIVS

USER_TABLES

USER_TABLESPACES

USER_TAB_COLUMNS

USER_TAB_COMMENTS

USER_TAB_PRIVS

USER_TAB_PRIVS_MADE

USER_TAB_PRIVS_RECD

USER_TRIGGERS

USER_TS_QUOTAS

USER_USERS

USER_VIEWS



참고 사이트

'컴퓨터활용 > 오라클' 카테고리의 다른 글

오라클 유저 생성  (0) 2003.10.12
oracle listener status check  (0) 2003.10.12
ORACLE export / import 예제  (0) 2003.10.12
PRIMARY KEY 생성하기  (0) 2003.10.12
MYSQL 주의점  (1) 2003.10.12