|
|
|
Oracle Data Dictionary Views
A dump of the Oracle 8.1.6 Data Dictionary. Also see Oracle V$ performance views.
DBA_2PC_NEIGHBORS
DBA_2PC_PENDING
DBA_ALL_TABLES ALL_ALL_TABLES USER_ALL_TABLES
DBA_ANALYZE_OBJECTS
ALL_ARGUMENTS USER_ARGUMENTS
DBA_ASSOCIATIONS ALL_ASSOCIATIONS USER_ASSOCIATIONS
DBA_AUDIT_EXISTS
DBA_AUDIT_OBJECT USER_AUDIT_OBJECT
DBA_AUDIT_SESSION USER_AUDIT_SESSION
DBA_AUDIT_STATEMENT USER_AUDIT_STATEMENT
DBA_AUDIT_TRAIL USER_AUDIT_TRAIL
c
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 SM$INTEGRITY_CONS
DBA_CONS_COLUMNS ALL_CONS_COLUMNS USER_CONS_COLUMNS
DBA_CONTEXT ALL_CONTEXT
d
DBA_DATA_FILES
DATABASE_COMPATIBLE_LEVEL
DBA_DB_LINKS ALL_DB_LINKS USER_DB_LINKS
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_EXP_FILES
DBA_EXP_OBJECTS
DBA_EXP_VERSION
DBA_EXTENTS USER_EXTENTS
f
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
GLOBAL_NAME
i
ALL_IDS
DBA_INDEXES ALL_INDEXES USER_INDEXES
INDEX_HISTOGRAM
INDEX_STATS
DBA_INDEXTYPES ALL_INDEXTYPES USER_INDEXTYPES
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_POLICY USER_JAVA_POLICY
DBA_JOBS USER_JOBS
DBA_JOBS_RUNNING
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
m
DBA_METHOD_PARAMS ALL_METHOD_PARAMS USER_METHOD_PARAMS
DBA_METHOD_RESULTS ALL_METHOD_RESULTS USER_METHOD_RESULTS
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
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_OPANCILLARY ALL_OPANCILLARY USER_OPANCILLARY
DBA_OPARGUMENTS ALL_OPARGUMENTS USER_OPARGUMENTS
DBA_OPBINDINGS ALL_OPBINDINGS USER_OPBINDINGS
DBA_OPERATORS ALL_OPERATORS USER_OPERATORS
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_POLICIES ALL_POLICIES USER_POLICIES
DBA_PRIV_AUDIT_OPTS
ALL_PROBE_OBJECTS
DBA_PROFILES
q
DBA_QUEUES ALL_QUEUES USER_QUEUES
QUEUE_PRIVILEGES
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_SNAPSHOTS ALL_REGISTERED_SNAPSHOTS USER_REGISTERED_SNAPSHOTS
DBA_REGISTERED_SNAPSHOT_GROUPS
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_REPCATLOG ALL_REPCATLOG USER_REPCATLOG
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
_ALL_REPCOLUMN
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_REPFLAVORS ALL_REPFLAVORS USER_REPFLAVORS
DBA_REPFLAVOR_COLUMNS ALL_REPFLAVOR_COLUMNS USER_REPFLAVOR_COLUMNS
_ALL_REPFLAVOR_OBJECTS
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 RESOURCE_COST
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
USER_RESOURCE_LIMITS
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_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_LOG_FILTER_COLS
DBA_SNAPSHOT_REFRESH_TIMES ALL_SNAPSHOT_REFRESH_TIMES USER_SNAPSHOT_REFRESH_TIMES
DBA_SOURCE ALL_SOURCE USER_SOURCE
DBA_STMT_AUDIT_OPTS
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
ALL_SUMDELTA
DBA_SUMMARIES
DBA_SYNONYMS ALL_SYNONYMS USER_SYNONYMS 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_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_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
u
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
DBA_USTATS ALL_USTATS USER_USTATS
v
DBA_VARRAYS ALL_VARRAYS USER_VARRAYS
PRODUCT_COMPONENT_VERSION
DBA_VIEWS ALL_VIEWS USER_VIEWS
Other dictionary views below
DEFCALL
DEFCALLDEST
DEFDEFAULTDEST
DEFERRCOUNT
DEFERROR
DEFLOB
DEFPROPAGATOR
DEFSCHEDULE
DEFTRAN
DEFTRANDEST
HS_ALL_CAPS
HS_ALL_DD
HS_ALL_INITS
HS_BASE_CAPS
HS_BASE_DD
HS_CLASS_CAPS
HS_CLASS_DD
HS_CLASS_INIT
HS_EXTERNAL_OBJECTS
HS_EXTERNAL_OBJECT_PRIVILEGES
HS_EXTERNAL_USER_PRIVILEGES
HS_FDS_CLASS
HS_FDS_INST
HS_INST_CAPS
HS_INST_DD
HS_INST_INIT
IMP7UEC
IMP8CDT
IMP8CDTU
IMP8CON
IMP8REPCAT
IMP8TTD
IMP8TTDU
IMP8UEC
JAVASNM
LOADER_CONSTRAINT_INFO
LOADER_FILE_TS
LOADER_PARAM_INFO
LOADER_PART_INFO
LOADER_REF_INFO
LOADER_TAB_INFO
LOADER_TRIGGER_INFO
ORA_KGLR7_DB_LINKS
ORA_KGLR7_DEPENDENCIES
ORA_KGLR7_IDL_CHAR
ORA_KGLR7_IDL_SB4
ORA_KGLR7_IDL_UB1
ORA_KGLR7_IDL_UB2
ORA_KGLR7_OBJECTS
ORDER_OBJECT_BY_DEPENDENCY
PARSED_PIECES
PARSED_SIZE
PLUGGABLE_SET_CHECK
PRODUCT_COMPONENT_VERSION
PROXY_USERS
PS1$
PSS1$
PUBLIC_DEPENDENCY
REPCAT$_CDEF
REPCAT_GENERATED
REPCAT_REPCAT
REPCAT_REPCATLOG
REPCAT_REPOBJECT
REPCAT_REPOBJECT_BASE
REPCAT_REPPROP
REPCAT_REPSCHEMA
SM$AUDIT_CONFIG
SM$TS_AVAIL
SM$TS_FREE
SM$TS_USED
SM_$VERSION
SOURCE_SIZE
STRADDLING_RS_OBJECTS
STRADDLING_TS_OBJECTS
SYSSEGOBJ
TRUSTED_SERVERS
TSP$
TS_PITR_CHECK
TS_PITR_INFO
TS_PITR_OBJECTS_TO_BE_DROPPED
TS_PLUG_INFO
UNI_PLUGGABLE_SET_CHECK
