Table Name
| Description
|
ALL_ALL_TABLES
| Description of all object and relational tables accessible to the user
|
ALL_ALL_TABLES
| Description of all object and relational tables accessible to the user
|
ALL_APPLY
| Details about each apply process that dequeues from the queue visible to the current user
|
ALL_APPLY_CONFLICT_COLUMNS
| Details about conflict resolution on tables visible to the current user
|
ALL_APPLY_DML_HANDLERS
| Details about the dml handler on tables visible to the current user
|
ALL_APPLY_ERROR
| Error transactions that were generated after dequeuing from the queue visible to the current user
|
ALL_APPLY_KEY_COLUMNS
| Alternative key columns for a STREAMS table visible to the current user
|
ALL_APPLY_PARAMETERS
| Details about parameters of each apply process that dequeues from the queue visible to the current user
|
ALL_APPLY_PROGRESS
| Information about the progress made by the apply process that dequeues from the queue visible to the current user
|
ALL_ARGUMENTS
| Arguments in object accessible to the user
|
ALL_ASSOCIATIONS
| All associations available to the user
|
ALL_AUDIT_POLICIES
| All fine grained auditing policies in the database
|
ALL_BASE_TABLE_MVIEWS
| All materialized views with log(s) in the database that the user can see
|
ALL_CAPTURE
| Details about each capture process that stores the captured changes in a queue visible to the current user
|
ALL_CAPTURE_PARAMETERS
| Details about parameters for each capture process that stores the captured changes in a queue visible to the current user
|
ALL_CAPTURE_PREPARED_DATABASE
| Is the local database prepared for instantiation?
|
ALL_CAPTURE_PREPARED_SCHEMAS
| All user schemas at the local database that are prepared for instantiation
|
ALL_CAPTURE_PREPARED_TABLES
| All tables visible to the current user that are prepared for instantiation
|
ALL_CATALOG
| All tables, views, synonyms, sequences accessible to the user
|
ALL_CLUSTERS
| Description of clusters accessible to the user
|
ALL_CLUSTER_HASH_EXPRESSIONS
| Hash functions for all accessible clusters
|
ALL_COLL_TYPES
| Description of named collection types accessible to the user
|
ALL_COL_COMMENTS
| Comments on columns of accessible tables and views
|
ALL_COL_PRIVS
| Grants on columns for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
|
ALL_COL_PRIVS_MADE
| Grants on columns for which the user is owner or grantor
|
ALL_COL_PRIVS_RECD
| Grants on columns for which the user, PUBLIC or enabled role is the grantee
|
ALL_CONSTRAINTS
| Constraint definitions on accessible tables
|
ALL_CONS_COLUMNS
| Information about accessible columns in constraint definitions
|
ALL_CONS_OBJ_COLUMNS
| List of types an object column or attribute is constrained to in the tables accessible to the user
|
ALL_CONTEXT
| Description of all active context namespaces under the current session
|
ALL_DB_LINKS
| Database links accessible to the user
|
ALL_DEF_AUDIT_OPTS
| Auditing options for newly created objects
|
ALL_DEPENDENCIES
| Dependencies to and from objects accessible to the user
|
ALL_DIMENSIONS
| Description of the dimension objects accessible to the DBA
|
ALL_DIM_ATTRIBUTES
| Representation of the relationship between a dimension level and a functionally dependent column
|
ALL_DIM_CHILD_OF
| Representaion of a 1:n hierarchical relationship between a pair of levels in a dimension
|
ALL_DIM_HIERARCHIES
| Representation of a dimension hierarchy
|
ALL_DIM_JOIN_KEY
| Representation of a join between two dimension tables.
|
ALL_DIM_LEVELS
| Description of dimension levels visible to DBA
|
ALL_DIM_LEVEL_KEY
| Representations of columns of a dimension level
|
ALL_DIRECTORIES
| Description of all directories accessible to the user
|
ALL_ERRORS
| Current errors on stored objects that user is allowed to create
|
ALL_EVALUATION_CONTEXTS
| rule evaluation contexts seen by user
|
ALL_EVALUATION_CONTEXT_TABLES
| tables in all rule evaluation contexts seen by the user
|
ALL_EVALUATION_CONTEXT_VARS
| variables in all rule evaluation contexts seen by the user
|
ALL_EXTERNAL_LOCATIONS
| Description of the external tables locations accessible to the user
|
ALL_EXTERNAL_TABLES
| Description of the external tables accessible to the user
|
ALL_HISTOGRAMS
| Synonym for ALL_TAB_HISTOGRAMS
|
ALL_INDEXES
| Descriptions of indexes on tables accessible to the user
|
ALL_INDEXTYPES
| All indextypes available to the user
|
ALL_INDEXTYPE_COMMENTS
| Comments for user-defined indextypes
|
ALL_INDEXTYPE_OPERATORS
| All operators available to the user
|
ALL_IND_COLUMNS
| COLUMNs comprising INDEXes on accessible TABLES
|
ALL_IND_EXPRESSIONS
| FUNCTIONAL INDEX EXPRESSIONs on accessible TABLES
|
ALL_IND_PARTITIONS
|
|
ALL_IND_SUBPARTITIONS
|
|
ALL_INTERNAL_TRIGGERS
| Description of the internal triggers on the tables accessible to the user
|
ALL_JAVA_ARGUMENTS
| argument information of stored java class accessible to the user
|
ALL_JAVA_CLASSES
| class level information of stored java class accessible to the user
|
ALL_JAVA_DERIVATIONS
| this view maps java source objects and their derived java class objects and java resource objects for the java class accessible to user
|
ALL_JAVA_FIELDS
| field information of stored java class accessible to user
|
ALL_JAVA_IMPLEMENTS
| interfaces implemented by the stored java class accessible to the user
|
ALL_JAVA_INNERS
| list of inner classes refered by the stored java class accessible to user
|
ALL_JAVA_LAYOUTS
| class layout information about stored java class accessible to the user
|
ALL_JAVA_METHODS
| method information of stored java class accessible to user
|
ALL_JAVA_NCOMPS
| ncomp related information of all java classes
|
ALL_JAVA_RESOLVERS
| resolver of java class owned by user
|
ALL_JAVA_THROWS
| list of exceptions thrown from a method of a class accessible to user
|
ALL_JOBS
| Synonym for USER_JOBS
|
ALL_JOIN_IND_COLUMNS
| Join Index columns comprising the join conditions
|
ALL_LIBRARIES
| Description of libraries accessible to the user
|
ALL_LOBS
| Description of LOBs contained in tables accessible to the user
|
ALL_LOB_PARTITIONS
|
|
ALL_LOB_SUBPARTITIONS
|
|
ALL_LOB_TEMPLATES
|
|
ALL_LOG_GROUPS
| Log group definitions on accessible tables
|
ALL_LOG_GROUP_COLUMNS
| Information about columns in log group definitions
|
ALL_METHOD_PARAMS
| Description of method parameters of types accessible to the user
|
ALL_METHOD_RESULTS
| Description of method results of types accessible to the user
|
ALL_MVIEWS
| All materialized views in the database
|
ALL_MVIEW_AGGREGATES
| Description of the materialized view aggregates accessible to the user
|
ALL_MVIEW_ANALYSIS
| Description of the materialized views accessible to the user
|
ALL_MVIEW_DETAIL_RELATIONS
| Description of the materialized view detail tables accessible to the user
|
ALL_MVIEW_JOINS
| Description of a join between two columns in the WHERE clause of a materialized view accessible to the user
|
ALL_MVIEW_KEYS
| Description of the columns that appear in the GROUP BY list of a materialized view accessible to the user
|
ALL_MVIEW_LOGS
| All materialized view logs in the database that the user can see
|
ALL_MVIEW_REFRESH_TIMES
| Materialized views and their last refresh times for each master table that the user can look at
|
ALL_NESTED_TABLES
| Description of nested tables in tables accessible to the user
|
ALL_OBJECTS
| Objects accessible to the user
|
ALL_OBJECT_TABLES
| Description of all object tables accessible to the user
|
ALL_OBJ_COLATTRS
| Description of object columns and attributes contained in the tables accessible to the user
|
ALL_OPANCILLARY
| All ancillary operators available to the user
|
ALL_OPARGUMENTS
| All arguments of the operators available to the user
|
ALL_OPBINDINGS
| All binding functions for operators available to the user
|
ALL_OPERATORS
| All operators available to the user
|
ALL_OPERATOR_COMMENTS
| Comments for user-defined operators
|
ALL_OUTLINES
| Synonym for USER_OUTLINES
|
ALL_OUTLINE_HINTS
| Synonym for USER_OUTLINE_HINTS
|
ALL_PARTIAL_DROP_TABS
| All tables with patially dropped columns accessible to the user
|
ALL_PART_COL_STATISTICS
|
|
ALL_PART_HISTOGRAMS
|
|
ALL_PART_INDEXES
|
|
ALL_PART_KEY_COLUMNS
|
|
ALL_PART_LOBS
|
|
ALL_PART_TABLES
|
|
ALL_PENDING_CONV_TABLES
| All tables accessible to the user which are not upgraded to the latest type version
|
ALL_POLICIES
| All policies for objects if the user has system privileges or owns the objects
|
ALL_POLICY_CONTEXTS
| All policy driving context defined for all synonyms, tables, or views accessable to the user
|
ALL_POLICY_GROUPS
| All policy groups defined for any synonym, table or view accessable to the user
|
ALL_PROBE_OBJECTS
|
|
ALL_PROCEDURES
| Description of all procedures available to the user
|
ALL_PROPAGATION
| Streams propagation seen by the user
|
ALL_PUBLISHED_COLUMNS
|
|
ALL_QUEUES
| All queues accessible to the user
|
ALL_QUEUE_PUBLISHERS
|
|
ALL_QUEUE_TABLES
| All queue tables accessible to the user
|
ALL_REFRESH
| All the refresh groups that the user can touch
|
ALL_REFRESH_CHILDREN
| All the objects in refresh groups, where the user can touch the group
|
ALL_REFRESH_DEPENDENCIES
| Description of the detail tables that materialized views depend on for refresh
|
ALL_REFS
| Description of REF columns contained in tables accessible to the user
|
ALL_REGISTERED_MVIEWS
| Remote materialized views of local tables that the user can see
|
ALL_REGISTERED_SNAPSHOTS
| Remote snapshots of local tables that the user can see
|
ALL_REGISTRY_BANNERS
|
|
ALL_REPAUDIT_ATTRIBUTE
| Information about attributes automatically maintained for replication
|
ALL_REPAUDIT_COLUMN
| Information about columns in all shadow tables for replicated tables which are accessible to the user
|
ALL_REPCAT
|
|
ALL_REPCATLOG
| Information about asynchronous administration requests
|
ALL_REPCAT_REFRESH_TEMPLATES
|
|
ALL_REPCAT_TEMPLATE_OBJECTS
|
|
ALL_REPCAT_TEMPLATE_PARMS
|
|
ALL_REPCAT_TEMPLATE_SITES
|
|
ALL_REPCAT_USER_AUTHORIZATIONS
|
|
ALL_REPCAT_USER_PARM_VALUES
|
|
ALL_REPCOLUMN
| Replicated top-level columns (table) sorted alphabetically in ascending order
|
ALL_REPCOLUMN_GROUP
| All column groups of replicated tables which are accessible to the user
|
ALL_REPCONFLICT
| All conflicts with available resolutions for user's replicated tables
|
ALL_REPDDL
| Arguments that do not fit in a single repcat log record
|
ALL_REPFLAVORS
| Flavors defined for replicated object groups
|
ALL_REPFLAVOR_COLUMNS
| Replicated columns in flavors
|
ALL_REPFLAVOR_OBJECTS
| Replicated objects in flavors
|
ALL_REPGENERATED
| Objects generated to support replication
|
ALL_REPGENOBJECTS
| Objects generated to support replication
|
ALL_REPGROUP
| Information about replicated object groups
|
ALL_REPGROUPED_COLUMN
| Columns in the all column groups of replicated tables which are accessible to the user
|
ALL_REPGROUP_PRIVILEGES
| Information about users who are registered for object group privileges
|
ALL_REPKEY_COLUMNS
| Primary columns for a table using column-level replication
|
ALL_REPOBJECT
| Information about replicated objects
|
ALL_REPPARAMETER_COLUMN
| All columns used for resolving conflicts in replicated tables which are accessible to the user
|
ALL_REPPRIORITY
| Values and their corresponding priorities in all priority groups which are accessible to the user
|
ALL_REPPRIORITY_GROUP
| Information about all priority groups which are accessible to the user
|
ALL_REPPROP
| Propagation information about replicated objects
|
ALL_REPRESOLUTION
| Description of all conflict resolutions for replicated tables which are accessible to the user
|
ALL_REPRESOLUTION_METHOD
| All conflict resolution methods accessible to the user
|
ALL_REPRESOLUTION_STATISTICS
| Statistics for conflict resolutions for replicated tables which are accessible to the user
|
ALL_REPRESOL_STATS_CONTROL
| Information about statistics collection for conflict resolutions for replicated tables which are accessible to the user
|
ALL_REPSCHEMA
| N-way replication information
|
ALL_REPSITES
| N-way replication information
|
ALL_RULES
| Rules seen by the user
|
ALL_RULESETS
| Rulesets seen by the user: maintained for backward compatibility
|
ALL_RULE_SETS
| Rule sets seen by the user
|
ALL_RULE_SET_RULES
| Rules in all rule sets seen by the user
|
ALL_SECONDARY_OBJECTS
| All secondary objects for domain indexes
|
ALL_SEQUENCES
| Description of SEQUENCEs accessible to the user
|
ALL_SNAPSHOTS
| Snapshots the user can access
|
ALL_SNAPSHOT_LOGS
| All snapshot logs in the database that the user can see
|
ALL_SNAPSHOT_REFRESH_TIMES
| Synonym for ALL_MVIEW_REFRESH_TIMES
|
ALL_SOURCE
| Current source on stored objects that user is allowed to create
|
ALL_SOURCE_TABLES
|
|
ALL_SOURCE_TAB_COLUMNS
|
|
ALL_SQLJ_TYPES
| Description of types accessible to the user
|
ALL_SQLJ_TYPE_ATTRS
| Description of attributes of types accessible to the user
|
ALL_SQLJ_TYPE_METHODS
| Description of methods of types accessible to the user
|
ALL_STORED_SETTINGS
| Parameter settings for objects accessible to the user
|
ALL_STREAMS_GLOBAL_RULES
| Global rules created on the streams capture/apply/propagation process that interact with the queue visible to the current user
|
ALL_STREAMS_SCHEMA_RULES
| Rules created by streams administrative APIs on all user schemas
|
ALL_STREAMS_TABLE_RULES
| Rules created by streams administrative APIs on tables visible to the current user
|
ALL_SUBPARTITION_TEMPLATES
|
|
ALL_SUBPART_COL_STATISTICS
|
|
ALL_SUBPART_HISTOGRAMS
|
|
ALL_SUBPART_KEY_COLUMNS
|
|
ALL_SUBSCRIBED_COLUMNS
|
|
ALL_SUBSCRIBED_TABLES
|
|
ALL_SUBSCRIPTIONS
|
|
ALL_SUMDELTA
| Direct path load entries accessible to the user
|
ALL_SUMMARIES
| Description of the summaries accessible to the user
|
ALL_SUMMARY_AGGREGATES
|
|
ALL_SUMMARY_DETAIL_TABLES
|
|
ALL_SUMMARY_JOINS
|
|
ALL_SUMMARY_KEYS
|
|
ALL_SYNONYMS
| All synonyms accessible to the user
|
ALL_TABLES
| Description of relational tables accessible to the user
|
ALL_TAB_COLS
| Columns of user's tables, views and clusters
|
ALL_TAB_COLUMNS
| Columns of user's tables, views and clusters
|
ALL_TAB_COL_STATISTICS
| Columns of user's tables, views and clusters
|
ALL_TAB_COMMENTS
| Comments on tables and views accessible to the user
|
ALL_TAB_HISTOGRAMS
| Histograms on columns of all tables visible to user
|
ALL_TAB_MODIFICATIONS
| Information regarding modifications to tables
|
ALL_TAB_PARTITIONS
|
|
ALL_TAB_PRIVS
| Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
|
ALL_TAB_PRIVS_MADE
| User's grants and grants on user's objects
|
ALL_TAB_PRIVS_RECD
| Grants on objects for which the user, PUBLIC or enabled role is the grantee
|
ALL_TAB_SUBPARTITIONS
|
|
ALL_TRIGGERS
| Triggers accessible to the current user
|
ALL_TRIGGER_COLS
| Column usage in user's triggers or in triggers on user's tables
|
ALL_TYPES
| Description of types accessible to the user
|
ALL_TYPE_ATTRS
| Description of attributes of types accessible to the user
|
ALL_TYPE_METHODS
| Description of methods of types accessible to the user
|
ALL_TYPE_VERSIONS
| Description of each type version accessible to the user
|
ALL_UNUSED_COL_TABS
| All tables with unused columns accessible to the user
|
ALL_UPDATABLE_COLUMNS
| Description of all updatable columns
|
ALL_USERS
| Information about all users of the database
|
ALL_USTATS
| All statistics
|
ALL_VARRAYS
| Description of varrays in tables accessible to the user
|
ALL_VIEWS
| Description of views accessible to the user
|
ALL_WORKSPACES
|
|
DBA_ALL_TABLES
| Description of all object and relational tables in the database
|
GV$DLM_ALL_LOCKS
| Synonym for GV_$DLM_ALL_LOCKS
|
GV$SQL_PLAN_STATISTICS_ALL
| Synonym for GV_$SQL_PLAN_STATISTICS_ALL
|
USER_ALL_TABLES
| Description of all object and relational tables owned by the user's
|
V$DLM_ALL_LOCKS
| Synonym for V_$DLM_ALL_LOCKS
|
V$SQL_PLAN_STATISTICS_ALL
| Synonym for V_$SQL_PLAN_STATISTICS_ALL
|