Oracle Books, Websites etc

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  



Back to the Top

Simon Sheppard
SS64.com