数据字典一

[table]
|TABLE_NAME | COMMENTS|
| 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_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_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_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_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_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_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 | |
| ALL_XML_SCHEMAS | Description of all XML Schemas that user has privilege to reference|
| ALL_XML_TABLES | Description of the all XMLType tables that the user has privileges on|
| ALL_XML_TAB_COLS | Description of the all XMLType tables that the user has privileges on|
| ALL_XML_VIEWS | Description of the all XMLType views that the user has privileges on|
| ALL_XML_VIEW_COLS | Description of the all XMLType views that the user has privileges on|
| DBA_2PC_NEIGHBORS | information about incoming and outgoing connections for pending transactions|
| DBA_2PC_PENDING | info about distributed transactions awaiting recovery|
| DBA_ALL_TABLES | Description of all object and relational tables in the database|
| DBA_ANALYZE_OBJECTS | |
| DBA_APPLY | Details about the apply process|
| DBA_APPLY_CONFLICT_COLUMNS | Details about conflict resolution|
| DBA_APPLY_DML_HANDLERS | Details about the dml handler|
| DBA_APPLY_ERROR | Error transactions|
| DBA_APPLY_INSTANTIATED_OBJECTS | Details about objects instantiated|
| DBA_APPLY_KEY_COLUMNS | alternative key columns for a table for STREAMS|
| DBA_APPLY_PARAMETERS | All parameters for apply process|
| DBA_APPLY_PROGRESS | Information about the progress made by apply process|
| DBA_AQ_AGENTS | |
| DBA_AQ_AGENT_PRIVS | |
| DBA_ASSOCIATIONS | All associations|
| DBA_ATTRIBUTE_TRANSFORMATIONS | |
| DBA_AUDIT_EXISTS | Lists audit trail entries produced by AUDIT NOT EXISTS and AUDIT EXISTS|
| DBA_AUDIT_OBJECT | Audit trail records for statements concerning objects, specifically: table, cluster, view, index, sequence, [public] database link, [public] synonym, procedure, trigger, rollback segment, tablespace, role, user|
| DBA_AUDIT_POLICIES | All fine grained auditing policies in the database|
| DBA_AUDIT_SESSION | All audit trail records concerning CONNECT and DISCONNECT|
| DBA_AUDIT_STATEMENT | Audit trail records concerning grant, revoke, audit, noaudit and alter system|
| DBA_AUDIT_TRAIL | All audit trail entries|
| DBA_AWS | Analytic Workspaces in the database|
| DBA_AW_PS | Pagespaces in Analytic Workspaces owned by the user|
| DBA_BASE_TABLE_MVIEWS | All materialized views with log(s) in the database|
| DBA_BLOCKERS | |
| DBA_CACHEABLE_NONTABLE_OBJECTS | |
| DBA_CACHEABLE_OBJECTS | |
| DBA_CACHEABLE_OBJECTS_BASE | |
| DBA_CACHEABLE_TABLES | |
| DBA_CACHEABLE_TABLES_BASE | |
| DBA_CAPTURE | Details about the capture process|
| DBA_CAPTURE_PARAMETERS | All parameters for capture process|
| DBA_CAPTURE_PREPARED_DATABASE | Is the local database prepared for instantiation?|
| DBA_CAPTURE_PREPARED_SCHEMAS | All schemas at the local database that are prepared for instantiation|
| DBA_CAPTURE_PREPARED_TABLES | All tables prepared for instantiation|
| DBA_CATALOG | All database Tables, Views, Synonyms, Sequences|
| DBA_CLUSTERS | Description of all clusters in the database|
| DBA_CLUSTER_HASH_EXPRESSIONS | Hash functions for all clusters|
| DBA_CLU_COLUMNS | Mapping of table columns to cluster columns|
| DBA_COLL_TYPES | Description of all named collection types in the database|
| DBA_COL_COMMENTS | Comments on columns of all tables and views|
| DBA_COL_PRIVS | All grants on columns in the database|
| DBA_CONSTRAINTS | Constraint definitions on all tables|
| DBA_CONS_COLUMNS | Information about accessible columns in constraint definitions|
| DBA_CONS_OBJ_COLUMNS | List of types an object column or attribute is constrained to in all tables in the database|
| DBA_CONTEXT | Description of all context namespace information|
| DBA_DATA_FILES | Information about database data files|
| DBA_DB_LINKS | All database links in the database|
| DBA_DDL_LOCKS | |
| DBA_DEPENDENCIES | Dependencies to and from objects|
| DBA_DIMENSIONS | Description of the dimension objects accessible to the DBA|
| DBA_DIM_ATTRIBUTES | Representation of the relationship between a dimension level and
a functionally dependent column|
| DBA_DIM_CHILD_OF | Representaion of a 1:n hierarchical relationship between a pair of levels in
a dimension|
| DBA_DIM_HIERARCHIES | Representation of a dimension hierarchy|
| DBA_DIM_JOIN_KEY | Representation of a join between two dimension tables. |
| DBA_DIM_LEVELS | Description of dimension levels visible to DBA|
| DBA_DIM_LEVEL_KEY | Representations of columns of a dimension level|
| DBA_DIRECTORIES | Description of all directories|
| DBA_DML_LOCKS | |
| DBA_DMT_FREE_SPACE | Free extents in all dictionary managed tablespaces|
| DBA_DMT_USED_EXTENTS | All extents in the dictionary managed tablespaces|
| DBA_ERRORS | Current errors on all stored objects in the database|
| DBA_EVALUATION_CONTEXTS | rule evaluation contexts in the database|
| DBA_EVALUATION_CONTEXT_TABLES | tables in all rule evaluation contexts in the database|
| DBA_EVALUATION_CONTEXT_VARS | variables in all rule evaluation contexts in the database|
| DBA_EXP_FILES | Description of export files|
| DBA_EXP_OBJECTS | Objects that have been incrementally exported|
| DBA_EXP_VERSION | Version number of the last export session|
| DBA_EXTENTS | Extents comprising all segments in the database|
| DBA_EXTERNAL_LOCATIONS | Description of the external tables locations accessible to the DBA|
| DBA_EXTERNAL_TABLES | Description of the external tables accessible to the DBA|
| DBA_FGA_AUDIT_TRAIL | All fine grained audit event logs|
| DBA_FREE_SPACE | Free extents in all tablespaces|
| DBA_FREE_SPACE_COALESCED | Statistics on Coalesced Space in Tablespaces|
| DBA_GLOBAL_CONTEXT | Description of all context information accessible globally|
| 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 | Description for all indexes in the database|
| DBA_INDEXTYPES | All indextypes|
| DBA_INDEXTYPE_COMMENTS | Comments for user-defined indextypes|
| DBA_INDEXTYPE_OPERATORS | All indextype operators|
| DBA_IND_COLUMNS | COLUMNs comprising INDEXes on all TABLEs and CLUSTERs|
| DBA_IND_EXPRESSIONS | FUNCTIONAL INDEX EXPRESSIONs on all TABLES and CLUSTERS|
| DBA_IND_PARTITIONS | |
| DBA_IND_SUBPARTITIONS | |
| DBA_INTERNAL_TRIGGERS | Description of the internal triggers on all tables in the database|
| DBA_JAVA_ARGUMENTS | argument information of all stored java class|
| DBA_JAVA_CLASSES | class level information of all stored java classes|
| DBA_JAVA_DERIVATIONS | this view maps java source objects and their derived java class objects and java resource objects for all java classes|
| DBA_JAVA_FIELDS | field information of all stored java class|
| DBA_JAVA_IMPLEMENTS | interfaces implemented by the stored java class|
| DBA_JAVA_INNERS | list of inner classes refered by the stored java class|
| DBA_JAVA_LAYOUTS | class layout information about stored java class|
| DBA_JAVA_METHODS | method information of all stored java class|
| DBA_JAVA_NCOMPS | |
| DBA_JAVA_POLICY | java security Permissions for all users|
| DBA_JAVA_RESOLVERS | resolver of java class owned by user|
| DBA_JAVA_THROWS | list of exceptions thrown from a method of a class owned by user|
| DBA_JOBS | All jobs in the database|
| DBA_JOBS_RUNNING | All jobs in the database which are currently running, join v$lock and job$|
| DBA_JOIN_IND_COLUMNS | Join Index columns comprising the join conditions|
| DBA_KGLLOCK | |
| DBA_LIBRARIES | Description of all libraries in the database|
| DBA_LMT_FREE_SPACE | Free extents in all locally managed tablespaces|
| DBA_LMT_USED_EXTENTS | All extents in the locally managed tablespaces|
| DBA_LOBS | Description of LOBs contained in all tables|
| DBA_LOB_PARTITIONS | |
| DBA_LOB_SUBPARTITIONS | |
| DBA_LOB_TEMPLATES | |
| DBA_LOCK | |
| DBA_LOCK_INTERNAL | |
| DBA_LOGSTDBY_EVENTS | Information on why logical standby events|
| DBA_LOGSTDBY_LOG | List the information about received logs from the primary|
| DBA_LOGSTDBY_NOT_UNIQUE | List of all the tables with out primary or unique key not null constraints|
| DBA_LOGSTDBY_PARAMETERS | Miscellaneous options and settings for Logical Standby|
| DBA_LOGSTDBY_PROGRESS | List the SCN values describing read and apply progress|
| DBA_LOGSTDBY_SKIP | List the skip settings choosen|
| DBA_LOGSTDBY_SKIP_TRANSACTION | List the transactions to be skipped|
| DBA_LOGSTDBY_UNSUPPORTED | List of all the columns that are not supported by Logical Standby|
| DBA_LOG_GROUPS | Log group definitions on all tables|
| DBA_LOG_GROUP_COLUMNS | Information about columns in log group definitions|
| DBA_METHOD_PARAMS | Description of method parameters of all types in the database|
| DBA_METHOD_RESULTS | Description of method results of all types in the database|
| DBA_MVIEWS | All materialized views in the database|
| DBA_MVIEW_AGGREGATES | Description of the materialized view aggregates accessible to dba|
| DBA_MVIEW_ANALYSIS | Description of the materialized views accessible to dba|
| DBA_MVIEW_DETAIL_RELATIONS | Description of the materialized view detail tables accessible to dba|
| DBA_MVIEW_JOINS | Description of a join between two columns in the
WHERE clause of a materialized view accessible to dba|
| DBA_MVIEW_KEYS | Description of the columns that appear in the GROUP BY
list of a materialized view accessible to dba|
| DBA_MVIEW_LOGS | All materialized view logs in the database|
| DBA_MVIEW_LOG_FILTER_COLS | All filter columns (excluding PK cols) being logged in the materialized view logs|
| DBA_MVIEW_REFRESH_TIMES | All fast refreshable materialized views and their last refresh times for each master table|
| DBA_NESTED_TABLES | Description of nested tables contained in all tables|
| DBA_OBJECTS | All objects in the database|
| DBA_OBJECT_SIZE | Sizes, in bytes, of various pl/sql objects|
| DBA_OBJECT_TABLES | Description of all object tables in the database|
| DBA_OBJ_AUDIT_OPTS | Auditing options for all tables and views|
| DBA_OBJ_COLATTRS | Description of object columns and attributes contained in all tables in the database|
| DBA_OPANCILLARY | All ancillary operators|
| DBA_OPARGUMENTS | All operator arguments|
| DBA_OPBINDINGS | All operator binding functiosn or methods|
| DBA_OPERATORS | All operators|
| DBA_OPERATOR_COMMENTS | Comments for user-defined operators|
| DBA_OUTLINES | Stored outlines|
| DBA_OUTLINE_HINTS | Hints stored in outlines|
| DBA_PARTIAL_DROP_TABS | All tables with partially dropped columns in the database|
| DBA_PART_COL_STATISTICS | |
| DBA_PART_HISTOGRAMS | |
| DBA_PART_INDEXES | |
| DBA_PART_KEY_COLUMNS | |
| DBA_PART_LOBS | |
| DBA_PART_TABLES | |
| DBA_PENDING_CONV_TABLES | All tables which are not upgraded to the latest type version in the database|
| DBA_PENDING_TRANSACTIONS | information about unresolved global transactions|
| DBA_POLICIES | All row level security policies in the database|
| DBA_POLICY_CONTEXTS | All policy driving context defined for any synonym, table, or view in the database|
| DBA_POLICY_GROUPS | All policy groups defined for any synonym, table, view in the database|
| DBA_PRIV_AUDIT_OPTS | Describes current system privileges being audited across the system and by user|
| DBA_PROCEDURES | Description of all procedures|
| DBA_PROFILES | Display all profiles and their limits|
| DBA_PROPAGATION | Streams propagation in the database|
| DBA_PROXIES | Information about all proxy connections|
| DBA_PUBLISHED_COLUMNS | |
| DBA_QUEUES | All database queues|
| DBA_QUEUE_PUBLISHERS | |
| DBA_QUEUE_SCHEDULES | |
| DBA_QUEUE_TABLES | All queue tables created in the database|
| DBA_RCHILD | All the children in any refresh group. This view is not a join.|
| DBA_REFRESH | All the refresh groups|
| DBA_REFRESH_CHILDREN | All the objects in refresh groups|
| DBA_REFS | Description of REF columns contained in all tables|
| DBA_REGISTERED_MVIEWS | Remote materialized views of local tables|
| DBA_REGISTERED_MVIEW_GROUPS | Materialized view repgroup registration information|
| DBA_REGISTERED_SNAPSHOTS | Remote snapshots of local tables|
| DBA_REGISTERED_SNAPSHOT_GROUPS | Snapshot repgroup registration information|
| DBA_REGISTRY | |
| DBA_REGISTRY_HIERARCHY | |
| DBA_REPAUDIT_ATTRIBUTE | Information about attributes automatically maintained for replication|
| DBA_REPAUDIT_COLUMN | Information about columns in all shadow tables for all replicated tables in the database|
| DBA_REPCAT | |
| DBA_REPCATLOG | Information about asynchronous administration requests|
| DBA_REPCAT_EXCEPTIONS | Repcat processing exceptions table.|
| DBA_REPCOLUMN | Replicated top-level columns (table) sorted alphabetically in ascending order|
| DBA_REPCOLUMN_GROUP | All column groups of replicated tables in the database|
| DBA_REPCONFLICT | All conflicts for which users have specified resolutions in the database|
| DBA_REPDDL | Arguments that do not fit in a single repcat log record|
| DBA_REPEXTENSIONS | Information about replication extension requests|
| DBA_REPFLAVORS | Flavors defined for replicated object groups|
| DBA_REPFLAVOR_COLUMNS | Replicated columns in flavors|
| DBA_REPFLAVOR_OBJECTS | Replicated objects in flavors|
| DBA_REPGENERATED | Objects generated to support replication|
| DBA_REPGENOBJECTS | Objects generated to support replication|
| DBA_REPGROUP | Information about all replicated object groups|
| DBA_REPGROUPED_COLUMN | Columns in the all column groups of replicated tables in the database|
| DBA_REPGROUP_PRIVILEGES | Information about users who are registered for object group privileges|
| DBA_REPKEY_COLUMNS | Primary columns for a table using column-level replication|
| DBA_REPOBJECT | Information about replicated objects|
| DBA_REPPARAMETER_COLUMN | All columns used for resolving conflicts in the database|
| DBA_REPPRIORITY | Values and their corresponding priorities in all priority groups in the database|
| DBA_REPPRIORITY_GROUP | Information about all priority groups in the database|
| DBA_REPPROP | Propagation information about replicated objects|
| DBA_REPRESOLUTION | Description of all conflict resolutions in the database|
| DBA_REPRESOLUTION_METHOD | All conflict resolution methods in the database|
| DBA_REPRESOLUTION_STATISTICS | Statistics for conflict resolutions for all replicated tables in the database|
| DBA_REPRESOL_STATS_CONTROL | Information about statistics collection for conflict resolutions for all replicated tables in the database|
| DBA_REPSCHEMA | N-way replication information|
| DBA_REPSITES | N-way replication information|
| DBA_REPSITES_NEW | Information about new masters for replication extension|
| DBA_RESUMABLE | Resumable session information in the system|
| DBA_RGROUP | All refresh groups. This view is not a join.|
| DBA_ROLES | All Roles which exist in the database|
| DBA_ROLE_PRIVS | Roles granted to users and roles|
| DBA_ROLLBACK_SEGS | Description of rollback segments|
| DBA_RSRC_CONSUMER_GROUPS | all the resource consumer groups|
| DBA_RSRC_CONSUMER_GROUP_PRIVS | Switch privileges for consumer groups|
| DBA_RSRC_MANAGER_SYSTEM_PRIVS | system privileges for the resource manager|
| DBA_RSRC_PLANS | All the resource plans|
| DBA_RSRC_PLAN_DIRECTIVES | all the resource plan directives|
| DBA_RULES | Rules in the databse|
| DBA_RULESETS | Rulesets in the database: maintained for backward compatibility|
| DBA_RULE_SETS | Rule sets in the database|
| DBA_RULE_SET_RULES | Rules in all rule sets in the database|
| DBA_SECONDARY_OBJECTS | All secondary objects for domain indexes|
| DBA_SEGMENTS | Storage allocated for all database segments|
| DBA_SEQUENCES | Description of all SEQUENCEs in the database|
| DBA_SNAPSHOTS | All snapshots in the database|
| DBA_SNAPSHOT_LOGS | All snapshot logs in the database|
| DBA_SOURCE | Source of all stored objects in the database|
| DBA_SOURCE_TABLES | |
| DBA_SOURCE_TAB_COLUMNS | |
| DBA_SQLJ_TYPES | Description of all types in the database|
| DBA_SQLJ_TYPE_ATTRS | Description of attributes of all types in the database|
| DBA_SQLJ_TYPE_METHODS | Description of methods of all types in the database|
| DBA_STMT_AUDIT_OPTS | Describes current system auditing options across the system and by user|
| DBA_STORED_SETTINGS | Parameter settings for all objects|
| DBA_STREAMS_GLOBAL_RULES | Global rules created by streams administrative APIs|
| DBA_STREAMS_SCHEMA_RULES | Schema rules created by streams administrative APIs|
| DBA_STREAMS_TABLE_RULES | Table rules created by streams administrative APIs|
| DBA_SUBPARTITION_TEMPLATES | |
| DBA_SUBPART_COL_STATISTICS | |
| DBA_SUBPART_HISTOGRAMS | |
| DBA_SUBPART_KEY_COLUMNS | |
| DBA_SUBSCRIBED_COLUMNS | |
| DBA_SUBSCRIBED_TABLES | |
| DBA_SUBSCRIPTIONS | |
| DBA_SUMMARIES | Description of the summaries accessible to dba|
| DBA_SYNONYMS | All synonyms in the database|
| DBA_SYS_PRIVS | System privileges granted to users and roles|
| DBA_TABLES | Description of all relational tables in the database|
| DBA_TABLESPACES | Description of all tablespaces|
| DBA_TAB_COLS | Columns of user's tables, views and clusters|
| DBA_TAB_COLUMNS | Columns of user's tables, views and clusters|
| DBA_TAB_COL_STATISTICS | Columns of user's tables, views and clusters|
| DBA_TAB_COMMENTS | Comments on all tables and views in the database|
| DBA_TAB_HISTOGRAMS | Histograms on columns of all tables|
| DBA_TAB_MODIFICATIONS | Information regarding modifications to tables|
| DBA_TAB_PARTITIONS | |
| DBA_TAB_PRIVS | All grants on objects in the database|
| DBA_TAB_SUBPARTITIONS | |
| DBA_TEMPLATE_REFGROUPS | Table for maintaining refresh group information for template.|
| DBA_TEMPLATE_TARGETS | Internal table for tracking potential target databases for templates.|
| DBA_TEMP_FILES | Information about database temp files|
| DBA_TRANSFORMATIONS | |
| DBA_TRIGGERS | All triggers in the database|
| DBA_TRIGGER_COLS | Column usage in all triggers|
| DBA_TS_QUOTAS | Tablespace quotas for all users|
| DBA_TYPES | Description of all types in the database|
| DBA_TYPE_ATTRS | Description of attributes of all types in the database|
| DBA_TYPE_METHODS | Description of methods of all types in the database|
| DBA_TYPE_VERSIONS | Description of each type version in the database|
| DBA_UNDO_EXTENTS | Extents comprising all segments in the system managed undo tablespaces|
| DBA_UNUSED_COL_TABS | All tables with unused columns in the database|
| DBA_UPDATABLE_COLUMNS | Description of dba updatable columns|
| DBA_USERS | Information about all users of the database|
| DBA_USTATS | All statistics collected on either tables or indexes|
| DBA_VARRAYS | Description of varrays in tables accessible to the user|
| DBA_VIEWS | Description of all views in the database|
| DBA_WAITERS | |
| DBA_WORKSPACES | |
| DBA_WORKSPACE_SESSIONS | |
| DBA_XML_SCHEMAS | Description of all the XML Schemas registered|
| DBA_XML_TABLES | Description of all XML tables in the database|
| DBA_XML_TAB_COLS | Description of all XML tables in the database|
| DBA_XML_VIEWS | Description of all XML views in the database|
| DBA_XML_VIEW_COLS | Description of all XML views in the database|
[/table]