Oracle Data Dictionary

A dump of the Oracle Data Dictionary, also see: Oracle V$ Performance views.

DBA_ : sys계정이나 system계정에서만 확인 가능.
USER_ : 일반 계정에서 확인 가능.

DBA_2PC_NEIGHBORS
DBA_2PC_PENDING
DBA_ALL_TABLES       ALL_ALL_TABLES       USER_ALL_TABLES
DBA_ANALYZE_OBJECTS
DBA_APPLICATION_ROLES                     USER_APPLICATION_ROLES
DBA_APPLY            ALL_APPLY
DBA_APPLY_CONFLICT_COLUMNS ALL_APPLY_CONFLICT_COLUMNS
DBA_APPLY_DML_HANDLERS ALL_APPLY_DML_HANDLERS
DBA_APPLY_ERROR        ALL_APPLY_ERROR
DBA_APPLY_INSTANTIATED_OBJECTS
DBA_APPLY_KEY_COLUMNS ALL_APPLY_KEY_COLUMNS
DBA_APPLY_PARAMETERS ALL_APPLY_PARAMETERS
DBA_APPLY_PROGRESS   ALL_APPLY_PROGRESS
DBA_AQ_AGENTS
DBA_AQ_AGENT_PRIVS                        USER_AQ_AGENT_PRIVS
                      ALL_ARGUMENTS        USER_ARGUMENTS
DBA_ASSOCIATIONS     ALL_ASSOCIATIONS     USER_ASSOCIATIONS
                                           USER_ASTATUS_MAP
DBA_ATTRIBUTE_TRANSFORMATIONS    USER_ATTRIBUTE_TRANSFORMATIONS
DBA_AUDIT_EXISTS
DBA_AUDIT_OBJECT                          USER_AUDIT_OBJECT
DBA_AUDIT_POLICIES   ALL_AUDIT_POLICIES   USER_AUDIT_POLICIES
DBA_AUDIT_SESSION                         USER_AUDIT_SESSION
DBA_AUDIT_STATEMENT                       USER_AUDIT_STATEMENT
DBA_AUDIT_TRAIL                           USER_AUDIT_TRAIL
DBA_AWS                                   USER_AWS
DBA_AW_PS                                 USER_AW_PS
b
DBA_BLOCKERS
c
DBA_CACHEABLE_NONTABLE_OBJECTS
DBA_CACHEABLE_OBJECTS
DBA_CACHEABLE_OBJECTS_BASE
DBA_CACHEABLE_TABLES
DBA_CACHEABLE_TABLES_BASE
DBA_CAPTURE          ALL_CAPTURE 
DBA_CAPTURE_PARAMETERS ALL_CAPTURE_PARAMETERS
DBA_CAPTURE_PREPARED_DATABASE ALL_CAPTURE_PREPARED_DATABASE
DBA_CAPTURE_PREPARED_SCHEMAS ALL_CAPTURE_PREPARED_SCHEMAS
DBA_CAPTURE_PREPARED_TABLES ALL_CAPTURE_PREPARED_TABLES
DBA_CARTRIDGES
DBA_CARTRIDGE_COMPONENTS
DBA_CATALOG          ALL_CATALOG          USER_CATALOG         CATALOG
                                                                SYSCATALOG
                                                                SYSCATALOG_
DBA_CLUSTERS         ALL_CLUSTERS         USER_CLUSTERS       
DBA_CLUSTER_HASH_EXPRESSIONS  ALL_CLUSTER_HASH_EXPRESSIONS  USER_CLUSTER_HASH_EXPRESSIONS
DBA_CLU_COLUMNS                           USER_CLU_COLUMNS
                                                                CODE_PIECES
                                                                CODE_SIZE
DBA_COLL_TYPES       ALL_COLL_TYPES       USER_COLL_TYPES
                                                                COL
DBA_COL_COMMENTS     ALL_COL_COMMENTS     USER_COL_COMMENTS
DBA_COL_PRIVS        ALL_COL_PRIVS        USER_COL_PRIVS       COLUMN_PRIVILEGES
                      ALL_COL_PRIVS_MADE   USER_COL_PRIVS_MADE
                      ALL_COL_PRIVS_RECD   USER_COL_PRIVS_RECD
DBA_CONSTRAINTS      ALL_CONSTRAINTS      USER_CONSTRAINTS    
DBA_CONS_COLUMNS     ALL_CONS_COLUMNS     USER_CONS_COLUMNS
DBA_CONS_OBJ_COLUMNS ALL_CONS_OBJ_COLUMNS USER_CONS_OBJ_COLUMNS
DBA_CONTEXT          ALL_CONTEXT
d
DBA_DATA_FILES
                                                                DATABASE_COMPATIBLE_LEVEL
DBA_DB_LINKS         ALL_DB_LINKS         USER_DB_LINKS
DBA_DDL_LOCKS
DBA_DML_LOCKS
                      ALL_DEF_AUDIT_OPTS
DBA_DEPENDENCIES     ALL_DEPENDENCIES     USER_DEPENDENCIES
                                                                DICTIONARY
                                                                DICT_COLUMNS
                                                                DISK_AND_FIXED_OBJECTS
DBA_DIMENSIONS       ALL_DIMENSIONS       USER_DIMENSIONS
DBA_DIM_ATTRIBUTES   ALL_DIM_ATTRIBUTES   USER_DIM_ATTRIBUTES
DBA_DIM_CHILD_OF     ALL_DIM_CHILD_OF     USER_DIM_CHILD_OF
DBA_DIM_HIERARCHIES  ALL_DIM_HIERARCHIES  USER_DIM_HIERARCHIES
DBA_DIM_JOIN_KEY     ALL_DIM_JOIN_KEY     USER_DIM_JOIN_KEY
DBA_DIM_LEVELS       ALL_DIM_LEVELS       USER_DIM_LEVELS
DBA_DIM_LEVEL_KEY    ALL_DIM_LEVEL_KEY    USER_DIM_LEVEL_KEY
DBA_DIRECTORIES      ALL_DIRECTORIES
DBA_DMT_FREE_SPACE
DBA_DMT_USED_EXTENTS
e
DBA_ERRORS          
ALL_ERRORS : 현재 사용자가 접근 가능한 오브젝트의 에러 메시지를 보여준다.
        USER_ERRORS          ERROR_SIZE
DBA_EVALUATION_CONTEXTS  ALL_EVALUATION_CONTEXTS  USER_EVALUATION_CONTEXTS
DBA_EVALUATION_CONTEXT_TABLES ALL_EVALUATION_CONTEXT_TABLES USER_EVALUATION_CONTEXT_TABLES
DBA_EVALUATION_CONTEXT_VARS ALL_EVALUATION_CONTEXT_VARS USER_EVALUATION_CONTEXT_VARS
DBA_EXP_FILES
DBA_EXP_OBJECTS
DBA_EXP_VERSION
DBA_EXTENTS                               USER_EXTENTS
DBA_EXTERNAL_LOCATIONS ALL_EXTERNAL_LOCATIONS USER_EXTERNAL_LOCATIONS
DBA_EXTERNAL_TABLES    ALL_EXTERNAL_TABLES   USER_EXTERNAL_TABLES
f
DBA_FGA_AUDIT_TRAIL
                                                                FILEXT$
                                                                SYSFILES
DBA_FREE_SPACE                            USER_FREE_SPACE
DBA_FREE_SPACE_COALESCED
DBA_FREE_SPACE_COALESCED_TMP1
DBA_FREE_SPACE_COALESCED_TMP2
DBA_FREE_SPACE_COALESCED_TMP3
g
DBA_GLOBAL_CONTEXT                                             GLOBAL_NAME
i
DBA_IAS_CONSTRAINT_EXP
DBA_IAS_GEN_STMTS
DBA_IAS_GEN_STMTS_EXP
DBA_IAS_OBJECTS
DBA_IAS_OBJECTS_BASE
DBA_IAS_OBJECTS_EXP
DBA_IAS_POSTGEN_STMTS
DBA_IAS_PREGEN_STMTS
DBA_IAS_SITES
DBA_IAS_TEMPLATES
DBA_INDEXES          ALL_INDEXES         
USER_INDEXES : 해당 계정의 인덱스를 확인 할 수 있음.
                                                                INDEX_HISTOGRAM
                                                                INDEX_STATS
DBA_INDEXTYPES         ALL_INDEXTYPES         USER_INDEXTYPES
DBA_INDEXTYPE_COMMENTS ALL_INDEXTYPE_COMMENTS USER_INDEXTYPE_COMMENTS
DBA_INDEXTYPE_OPERATORS ALL_INDEXTYPE_OPERATORS USER_INDEXTYPE_OPERATORS
DBA_IND_COLUMNS        ALL_IND_COLUMNS        USER_IND_COLUMNS
DBA_IND_EXPRESSIONS    ALL_IND_EXPRESSIONS    USER_IND_EXPRESSIONS
DBA_IND_PARTITIONS     ALL_IND_PARTITIONS     USER_IND_PARTITIONS
DBA_IND_SUBPARTITIONS  ALL_IND_SUBPARTITIONS  USER_IND_SUBPARTITIONS
DBA_INTERNAL_TRIGGERS  ALL_INTERNAL_TRIGGERS  USER_INTERNAL_TRIGGERS
j
DBA_JAVA_ARGUMENTS   ALL_JAVA_ARGUMENTS   USER_JAVA_ARGUMENTS
DBA_JAVA_CLASSES     ALL_JAVA_CLASSES     USER_JAVA_CLASSES
DBA_JAVA_DERIVATIONS ALL_JAVA_DERIVATIONS USER_JAVA_DERIVATIONS
DBA_JAVA_FIELDS      ALL_JAVA_FIELDS      USER_JAVA_FIELDS
DBA_JAVA_IMPLEMENTS  ALL_JAVA_IMPLEMENTS  USER_JAVA_IMPLEMENTS
DBA_JAVA_INNERS      ALL_JAVA_INNERS      USER_JAVA_INNERS
DBA_JAVA_LAYOUTS     ALL_JAVA_LAYOUTS     USER_JAVA_LAYOUTS
DBA_JAVA_METHODS     ALL_JAVA_METHODS     USER_JAVA_METHODS
DBA_JAVA_NCOMPS      ALL_JAVA_NCOMPS      USER_JAVA_NCOMPS
DBA_JAVA_POLICY                           USER_JAVA_POLICY
DBA_JAVA_RESOLVERS   ALL_JAVA_RESOLVERS   USER_JAVA_RESOLVERS
DBA_JAVA_THROWS      ALL_JAVA_THROWS      USER_JAVA_THROWS
DBA_JOBS                                  USER_JOBS
DBA_JOBS_RUNNING
DBA_JOIN_IND_COLUMNS ALL_JOIN_IND_COLUMNS USER_JOIN_IND_COLUMNS
l
DBA_LIBRARIES        ALL_LIBRARIES        USER_LIBRARIES
DBA_LMT_FREE_SPACE                
DBA_LMT_USED_EXTENTS                  
DBA_LOBS             ALL_LOBS             USER_LOBS
DBA_LOB_PARTITIONS   ALL_LOB_PARTITIONS   USER_LOB_PARTITIONS 
DBA_LOB_SUBPARTITIONS ALL_LOB_SUBPARTITIONS USER_LOB_SUBPARTITIONS
DBA_LOB_TEMPLATES    ALL_LOB_TEMPLATES    USER_LOB_TEMPLATES
DBA_LOCK
DBA_LOCK_INTERNAL
DBA_LOG_GROUPS        ALL_LOG_GROUPS        USER_LOG_GROUPS
DBA_LOG_GROUP_COLUMNS ALL_LOG_GROUP_COLUMNS USER_LOG_GROUP_COLUMNS
DBA_LOGSTDBY_EVENTS
DBA_LOGSTDBY_LOG
DBA_LOGSTDBY_NOT_UNIQUE
DBA_LOGSTDBY_PARAMETERS
DBA_LOGSTDBY_PROGRESS
DBA_LOGSTDBY_SKIP
DBA_LOGSTDBY_SKIP_TRANSACTION
DBA_LOGSTDBY_UNSUPPORTED 
m
DBA_METHOD_PARAMS    ALL_METHOD_PARAMS    USER_METHOD_PARAMS  
DBA_METHOD_RESULTS   ALL_METHOD_RESULTS   USER_METHOD_RESULTS
DBA_BASE_TABLE_MVIEWS ALL_BASE_TABLE_MVIEWS USER_BASE_TABLE_MVIEWS
DBA_MVIEWS           ALL_MVIEWS           USER_MVIEWS
DBA_MVIEW_AGGREGATES ALL_MVIEW_AGGREGATES USER_MVIEW_AGGREGATES
DBA_MVIEW_ANALYSIS   ALL_MVIEW_ANALYSIS   USER_MVIEW_ANALYSIS
DBA_MVIEW_DETAIL_RELATIONS ALL_MVIEW_DETAIL_RELATIONS USER_MVIEW_DETAIL_RELATIONS
DBA_MVIEW_JOINS      ALL_MVIEW_JOINS      USER_MVIEW_JOINS
DBA_MVIEW_KEYS       ALL_MVIEW_KEYS       USER_MVIEW_KEYS
DBA_MVIEW_LOGS       ALL_MVIEW_LOGS       USER_MVIEW_LOGS
DBA_MVIEW_LOG_FILTER_COLS
DBA_MVIEW_REFRESH_TIMES ALL_MVIEW_REFRESH_TIMES USER_MVIEW_REFRESH_TIMES
n
DBA_NESTED_TABLES    ALL_NESTED_TABLES    USER_NESTED_TABLES
                                                                NLS_DATABASE_PARAMETERS
                                                                NLS_INSTANCE_PARAMETERS
                                                                NLS_SESSION_PARAMETERS
o
DBA_OBJECTS          ALL_OBJECTS          USER_OBJECTS         SYS_OBJECTS
DBA_OBJECT_SIZE                           USER_OBJECT_SIZE
DBA_OBJECT_TABLES    ALL_OBJECT_TABLES    USER_OBJECT_TABLES
DBA_OBJ_AUDIT_OPTS                        USER_OBJ_AUDIT_OPTS
DBA_OBJ_COLATTRS ALL_OBJ_COLATTRS USER_OBJ_COLATTRS
DBA_OPANCILLARY      ALL_OPANCILLARY      USER_OPANCILLARY
DBA_OPARGUMENTS      ALL_OPARGUMENTS      USER_OPARGUMENTS
DBA_OPBINDINGS       ALL_OPBINDINGS       USER_OPBINDINGS
DBA_OPERATORS        ALL_OPERATORS        USER_OPERATORS
DBA_OPERATOR_COMMENTS ALL_OPERATOR_COMMENTS USER_OPERATOR_COMMENTS
DBA_OUTLINES                              USER_OUTLINES
DBA_OUTLINE_HINTS                         USER_OUTLINE_HINTS
p
DBA_PARTIAL_DROP_TABS    ALL_PARTIAL_DROP_TABS    USER_PARTIAL_DROP_TABS
DBA_PART_COL_STATISTICS  ALL_PART_COL_STATISTICS  USER_PART_COL_STATISTICS
DBA_PART_HISTOGRAMS   ALL_PART_HISTOGRAMS   USER_PART_HISTOGRAMS 
DBA_PART_INDEXES      ALL_PART_INDEXES      USER_PART_INDEXES   
DBA_PART_KEY_COLUMNS  ALL_PART_KEY_COLUMNS  USER_PART_KEY_COLUMNS 
DBA_PART_LOBS         ALL_PART_LOBS         USER_PART_LOBS      
DBA_PART_TABLES       ALL_PART_TABLES       USER_PART_TABLES    
                                           USER_PASSWORD_LIMITS 
DBA_PENDING_TRANSACTIONS
DBA_PENDING_CONV_TABLES ALL_PENDING_CONV_TABLES USER_PENDING_CONV_TABLES
DBA_POLICIES         ALL_POLICIES         USER_POLICIES
DBA_POLICY_CONTEXTS  ALL_POLICY_CONTEXTS  USER_POLICY_CONTEXTS
DBA_POLICY_GROUPS    ALL_POLICY_GROUPS    USER_POLICY_GROUPS
DBA_PRIV_AUDIT_OPTS                  
                      ALL_PROBE_OBJECTS
DBA_PROCEDURES       ALL_PROCEDURES       USER_PROCEDURES
                                                       PRODUCT_PRIVS
DBA_PROFILES
DBA_PROPAGATION      ALL_PROPAGATION
DBA_PROXIES                               USER_PROXIES
DBA_PUBLISHED_COLUMNS ALL_PUBLISHED_COLUMNS USER_PUBLISHED_COLUMNS
    
q             
DBA_QUEUES           ALL_QUEUES           USER_QUEUES
                                                        QUEUE_PRIVILEGES
DBA_QUEUE_PUBLISHERS ALL_QUEUE_PUBLISHERS USER_QUEUE_PUBLISHERS
DBA_QUEUE_SCHEDULES                       USER_QUEUE_SCHEDULES
DBA_QUEUE_TABLES     ALL_QUEUE_TABLES     USER_QUEUE_TABLES
r
DBA_RCHILD
DBA_REFRESH          ALL_REFRESH          USER_REFRESH
DBA_REFRESH_CHILDREN ALL_REFRESH_CHILDREN USER_REFRESH_CHILDREN
                      ALL_REFRESH_DEPENDENCIES
DBA_REFS             ALL_REFS             USER_REFS
DBA_REGISTERED_MVIEWS ALL_REGISTERED_MVIEWS USER_REGISTERED_MVIEWS
DBA_REGISTERED_MVIEW_GROUPS
DBA_REGISTERED_SNAPSHOTS ALL_REGISTERED_SNAPSHOTS USER_REGISTERED_SNAPSHOTS
DBA_REGISTERED_SNAPSHOT_GROUPS
DBA_REGISTRY                              USER_REGISTRY
                      ALL_REGISTRY_BANNERS
DBA_REGISTRY_HIERARCHY
DBA_REPAUDIT_ATTRIBUTE ALL_REPAUDIT_ATTRIBUTE USER_REPAUDIT_ATTRIBUTE
DBA_REPAUDIT_COLUMN  ALL_REPAUDIT_COLUMN  USER_REPAUDIT_COLUMN
DBA_REPCAT           ALL_REPCAT           USER_REPCAT
DBA_REPCAT_EXCEPTIONS
DBA_REPCAT_REFRESH_TEMPLATES ALL_REPCAT_REFRESH_TEMPLATES USER_REPCAT_REFRESH_TEMPLATES
DBA_REPCAT_TEMPLATE_OBJECTS  ALL_REPCAT_TEMPLATE_OBJECTS  USER_REPCAT_TEMPLATE_OBJECTS
DBA_REPCAT_TEMPLATE_PARMS    ALL_REPCAT_TEMPLATE_PARMS  USER_REPCAT_TEMPLATE_PARMS
DBA_REPCAT_TEMPLATE_SITES    ALL_REPCAT_TEMPLATE_SITES  USER_REPCAT_TEMPLATE_SITES
DBA_REPCAT_USER_AUTHORIZATIONS  ALL_REPCAT_USER_AUTHORIZATIONS  USER_REPCAT_USER_AUTHORIZATION
DBA_REPCAT_USER_PARM_VALUES  ALL_REPCAT_USER_PARM_VALUES  USER_REPCAT_USER_PARM_VALUES
DBA_REPCATLOG        ALL_REPCATLOG        USER_REPCATLOG
DBA_REPCOLUMN        ALL_REPCOLUMN        USER_REPCOLUMN   
DBA_REPCOLUMN_GROUP  ALL_REPCOLUMN_GROUP  USER_REPCOLUMN_GROUP
DBA_REPCONFLICT      ALL_REPCONFLICT      USER_REPCONFLICT
DBA_REPDDL           ALL_REPDDL           USER_REPDDL
DBA_REPEXTENSIONS
DBA_REPFLAVORS       ALL_REPFLAVORS       USER_REPFLAVORS
DBA_REPFLAVOR_COLUMNS ALL_REPFLAVOR_COLUMNS USER_REPFLAVOR_COLUMNS
DBA_REPFLAVOR_OBJECTS ALL_REPFLAVOR_OBJECTS USER_REPFLAVOR_OBJECTS
DBA_REPGENERATED     ALL_REPGENERATED     USER_REPGENERATED
DBA_REPGENOBJECTS    ALL_REPGENOBJECTS    USER_REPGENOBJECTS
DBA_REPGROUP         ALL_REPGROUP         USER_REPGROUP
DBA_REPGROUPED_COLUMN ALL_REPGROUPED_COLUMN USER_REPGROUPED_COLUMN
DBA_REPGROUP_PRIVILEGES ALL_REPGROUP_PRIVILEGES USER_REPGROUP_PRIVILEGES
DBA_REPKEY_COLUMNS   ALL_REPKEY_COLUMNS   USER_REPKEY_COLUMNS
DBA_REPOBJECT        ALL_REPOBJECT        USER_REPOBJECT
DBA_REPPARAMETER_COLUMN  ALL_REPPARAMETER_COLUMN  USER_REPPARAMETER_COLUMN
DBA_REPPRIORITY       ALL_REPPRIORITY      USER_REPPRIORITY
DBA_REPPRIORITY_GROUP ALL_REPPRIORITY_GROUP USER_REPPRIORITY_GROUP
DBA_REPPROP           ALL_REPPROP           USER_REPPROP
DBA_REPRESOLUTION     ALL_REPRESOLUTION     USER_REPRESOLUTION
DBA_REPRESOLUTION_METHOD     ALL_REPRESOLUTION_METHOD   USER_REPRESOLUTION_METHOD
DBA_REPRESOLUTION_STATISTICS ALL_REPRESOLUTION_STATISTICS USER_REPRESOLUTION_STATISTICS
DBA_REPRESOL_STATS_CONTROL   ALL_REPRESOL_STATS_CONTROL USER_REPRESOL_STATS_CONTROL
DBA_REPSCHEMA        ALL_REPSCHEMA        USER_REPSCHEMA
DBA_REPSITES         ALL_REPSITES         USER_REPSITES
DBA_REPSITES_NEW
                                           USER_RESOURCE_LIMITS
                                                       RESOURCE_COST
DBA_RESUMABLE                             USER_RESUMABLE
DBA_RULES            ALL_RULES            USER_RULES
                      ALL_RULESETS
DBA_RULE_SETS 
                      ALL_RULE_SETS        USER_RULE_SETS
DBA_RULE_SET_RULES   ALL_RULE_SET_RULES   USER_RULE_SET_RULES

DBA_RGROUP
DBA_ROLES
DBA_ROLE_PRIVS                            USER_ROLE_PRIVS      ROLE_ROLE_PRIVS
DBA_ROLLBACK_SEGS
DBA_RSRC_CONSUMER_GROUPS
DBA_RSRC_CONSUMER_GROUP_PRIVS             USER_RSRC_CONSUMER_GROUP_PRIVS
DBA_RSRC_MANAGER_SYSTEM_PRIVS             USER_RSRC_MANAGER_SYSTEM_PRIVS
DBA_RSRC_PLANS
DBA_RSRC_PLAN_DIRECTIVES 
DBA_RULESETS                              USER_RULESETS

s

DBA_SCHEDULER_JOB_RUN_DETAILS : scheduler job의 성공여부와 에러메시지를 보여줌.

DBA_SECONDARY_OBJECTS ALL_SECONDARY_OBJECTS USER_SECONDARY_OBJECTS
DBA_SEGMENTS                              USER_SEGMENTS        SYS_DBA_SEGS
                                                                SYS_USER_SEGS
DBA_SEQUENCES        ALL_SEQUENCES        USER_SEQUENCES      
                                                                SESSION_ROLES
                                                                SESSION_PRIVS
                                                                SESSION_CONTEXT
DBA_SNAPSHOTS        ALL_SNAPSHOTS        USER_SNAPSHOTS
DBA_SNAPSHOT_LOGS    ALL_SNAPSHOT_LOGS    USER_SNAPSHOT_LOGS
DBA_SNAPSHOT_REFRESH_TIMES ALL_SNAPSHOT_REFRESH_TIMES USER_SNAPSHOT_REFRESH_TIMES
DBA_SOURCE           
ALL_SOURCE          
USER_SOURCE : procedure, function, package 의 소스를 확인 할 수 있음.
DBA_SOURCE_TABLES     ALL_SOURCE_TABLES    USER_SOURCE_TABLES
DBA_SOURCE_TAB_COLUMNS ALL_SOURCE_TAB_COLUMNS USER_SOURCE_TAB_COLUMNS
DBA_SQLJ_TYPES        ALL_SQLJ_TYPES        USER_SQLJ_TYPES
DBA_SQLJ_TYPE_ATTRS   ALL_SQLJ_TYPE_ATTRS   USER_SQLJ_TYPE_ATTRS
DBA_SQLJ_TYPE_METHODS ALL_SQLJ_TYPE_METHODS USER_SQLJ_TYPE_METHODS
DBA_STMT_AUDIT_OPTS
DBA_STORED_SETTINGS       ALL_STORED_SETTINGS    USER_STORED_SETTINGS
DBA_STREAMS_GLOBAL_RULES  ALL_STREAMS_GLOBAL_RULES
DBA_STREAMS_SCHEMA_RULES  ALL_STREAMS_SCHEMA_RULES
DBA_STREAMS_TABLE_RULES   ALL_STREAMS_TABLE_RULES
DBA_SUBPART_COL_STATISTICS ALL_SUBPART_COL_STATISTICS USER_SUBPART_COL_STATISTICS
DBA_SUBPART_HISTOGRAMS   ALL_SUBPART_HISTOGRAMS   USER_SUBPART_HISTOGRAMS
DBA_SUBPART_KEY_COLUMNS  ALL_SUBPART_KEY_COLUMNS  USER_SUBPART_KEY_COLUMNS
DBA_SUBPARTITION_TEMPLATES ALL_SUBPARTITION_TEMPLATES USER_SUBPARTITION_TEMPLATES
DBA_SUBSCRIBED_COLUMNS ALL_SUBSCRIBED_COLUMNS USER_SUBSCRIBED_COLUMNS
DBA_SUBSCRIBED_TABLES ALL_SUBSCRIBED_TABLES USER_SUBSCRIBED_TABLES
DBA_SUBSCRIPTIONS    ALL_SUBSCRIPTIONS    USER_SUBSCRIPTIONS
                      ALL_SUMDELTA
DBA_SUMMARIES        ALL_SUMMARIES        USER_SUMMARIES
DBA_SUMMARY_AGGREGATES ALL_SUMMARY_AGGREGATES  USER_SUMMARY_AGGREGATES
DBA_SUMMARY_DETAIL_TABLES ALL_SUMMARY_DETAIL_TABLES  USER_SUMMARY_DETAIL_TABLES
DBA_SUMMARY_JOINS    ALL_SUMMARY_JOINS    USER_SUMMARY_JOINS
DBA_SUMMARY_KEYS     ALL_SUMMARY_KEYS     USER_SUMMARY_KEYS
DBA_SYNONYMS         ALL_SYNONYMS         USER_SYNONYMS        PUBLICSYN
DBA_SYS_PRIVS                             USER_SYS_PRIVS       ROLE_SYS_PRIVS
t
DBA_ALL_TABLES       ALL_ALL_TABLES       USER_ALL_TABLES
DBA_TABLES           ALL_TABLES           USER_TABLES          TAB
DBA_TABLESPACES                           USER_TABLESPACES
DBA_TAB_COLUMNS      ALL_TAB_COLUMNS      USER_TAB_COLUMNS
DBA_TAB_COLS         ALL_TAB_COLS         USER_TAB_COLS
DBA_TAB_COL_STATISTICS  ALL_TAB_COL_STATISTICS  USER_TAB_COL_STATISTICS
DBA_TAB_COMMENTS     ALL_TAB_COMMENTS     USER_TAB_COMMENTS
DBA_TAB_HISTOGRAMS   ALL_TAB_HISTOGRAMS   USER_TAB_HISTOGRAMS
DBA_TAB_MODIFICATIONS  ALL_TAB_MODIFICATIONS  USER_TAB_MODIFICATIONS
DBA_TAB_PARTITIONS   ALL_TAB_PARTITIONS   USER_TAB_PARTITIONS
DBA_TAB_PRIVS        ALL_TAB_PRIVS        USER_TAB_PRIVS       TABLE_PRIVILEGES
                                                                ROLE_TAB_PRIVS
                      ALL_TAB_PRIVS_MADE   USER_TAB_PRIVS_MADE
                      ALL_TAB_PRIVS_RECD   USER_TAB_PRIVS_RECD
                                                                TABQUOTAS
DBA_TAB_SUBPARTITIONS  ALL_TAB_SUBPARTITIONS  USER_TAB_SUBPARTITIONS
DBA_TEMP_FILES
DBA_TEMPLATE_REFGROUPS
DBA_TEMPLATE_TARGETS
DBA_TRANSFORMATIONS                       USER_TRANSFORMATIONS
DBA_TRIGGERS         ALL_TRIGGERS         USER_TRIGGERS
DBA_TRIGGER_COLS     ALL_TRIGGER_COLS     USER_TRIGGER_COLS
DBA_TS_QUOTAS                             USER_TS_QUOTAS
DBA_TYPES            ALL_TYPES            USER_TYPES
DBA_TYPE_ATTRS       ALL_TYPE_ATTRS       USER_TYPE_ATTRS
DBA_TYPE_METHODS     ALL_TYPE_METHODS     USER_TYPE_METHODS
DBA_TYPE_VERSIONS    ALL_TYPE_VERSIONS    USER_TYPE_VERSIONS
u
DBA_UNDO_EXTENTS
DBA_UNUSED_COL_TABS  ALL_UNUSED_COL_TABS  USER_UNUSED_COL_TABS 
DBA_UPDATABLE_COLUMNS  ALL_UPDATABLE_COLUMNS  USER_UPDATABLE_COLUMNS 
DBA_USERS            ALL_USERS            USER_USERS         USER_HISTORY$
DBA_USTATS           ALL_USTATS           USER_USTATS
v
DBA_VARRAYS          ALL_VARRAYS          USER_VARRAYS
                                               PRODUCT_COMPONENT_VERSION
DBA_VIEWS            ALL_VIEWS            USER_VIEWS
w
DBA_WAITERS
DBA_WORKSPACES       ALL_WORKSPACES       USER_WORKSPACES
DBA_WORKSPACE_SESSIONS
x
DBA_XML_SCHEMAS      ALL_XML_SCHEMAS      USER_XML_SCHEMAS
DBA_XML_TABLES       ALL_XML_TABLES       USER_XML_TABLES
DBA_XML_TAB_COLS     ALL_XML_TAB_COLS     USER_XML_TAB_COLS
DBA_XML_VIEWS        ALL_XML_VIEWS        USER_XML_VIEWS
DBA_XML_VIEW_COLS    ALL_XML_VIEW_COLS    USER_XML_VIEW_COLS

[출처] http://ss64.com/orad/
select *
from USER_INDEXES
where TABLE_OWNER = 'GNEMINWON';