오라클 시스템 테이블
SystemTable |
Description |
ALL_ARGUMENTS |
Arguments in object |
ALL_CATALOG |
All tables, views, synonyms, |
ALL_COL_COMMENTS |
Comments on columns of |
ALL_CONSTRAINTS |
Constraint definitions on |
ALL_CONS_COLUMNS |
Information about accessible |
ALL_DB_LINKS |
Database links accessible to |
ALL_ERRORS |
Current errors on stored |
ALL_INDEXES |
Descriptions of indexes on |
ALL_IND_COLUMNS |
COLUMNs comprising INDEXes |
ALL_LOBS |
Description of LOBs |
ALL_OBJECTS |
Objects accessible to the |
ALL_OBJECT_TABLES |
Description of all object |
ALL_SEQUENCES |
Description of SEQUENCEs |
ALL_SNAPSHOTS |
Snapshots the user can |
ALL_SOURCE |
Current source on stored |
ALL_SYNONYMS |
All synonyms accessible to |
ALL_TABLES |
Description of relational |
ALL_TAB_COLUMNS |
Columns of user’s tables, |
ALL_TAB_COL_STATISTICS |
Columns of user’s tables, |
ALL_TAB_COMMENTS |
Comments on tables and views |
ALL_TRIGGERS |
Triggers accessible to the |
ALL_TRIGGER_COLS |
Column usage in user’s |
ALL_TYPES |
Description of types |
ALL_UPDATABLE_COLUMNS |
Description of all updatable |
ALL_USERS |
Information about all users |
ALL_VIEWS |
Description of views |
DATABASE_COMPATIBLE_LEVEL |
Database compatible |
DBA_DB_LINKS |
All database links in the |
DBA_ERRORS |
Current errors on all stored |
DBA_OBJECTS |
All objects in the |
DBA_ROLES |
All Roles which exist in the |
DBA_ROLE_PRIVS |
Roles granted to users and |
DBA_SOURCE |
Source of all stored objects |
DBA_TABLESPACES |
Description of all |
DBA_TAB_PRIVS |
All grants on objects in the |
DBA_TRIGGERS |
All triggers in the |
DBA_TS_QUOTAS |
Tablespace quotas for all |
DBA_USERS |
Information about all users |
DBA_VIEWS |
Description of all views in |
DICTIONARY |
Description of data |
DICT_COLUMNS |
Description of columns in |
GLOBAL_NAME |
global database |
NLS_DATABASE_PARAMETERS |
Permanent NLS parameters of |
NLS_INSTANCE_PARAMETERS |
NLS parameters of the |
NLS_SESSION_PARAMETERS |
NLS parameters of the user |
PRODUCT_COMPONENT_VERSION |
version and status |
ROLE_TAB_PRIVS |
Table privileges granted to |
SESSION_PRIVS |
Privileges which the user |
SESSION_ROLES |
Roles which the user |
SYSTEM_PRIVILEGE_MAP |
Description table for |
TABLE_PRIVILEGES |
Grants on objects for which |
TABLE_PRIVILEGE_MAP |
Description table for |
출처 : http://www.techonthenet.com/oracle/sys_tables/
최신 댓글