select * from dict
where table_name like 'DBA%'
TABLE_NAME | COMMENTS |
---|---|
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_HISTOGRAMS | Synonym for DBA_TAB_HISTOGRAMS |
DBA_LOCKS | Synonym for DBA_LOCK |
DBA_SNAPSHOT_LOG_FILTER_COLS | Synonym for DBA_MVIEW_LOG_FILTER_COLS |
DBA_SNAPSHOT_REFRESH_TIMES | Synonym for DBA_MVIEW_REFRESH_TIMES |