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 accessibleto the user |
ALL_METHOD_RESULTS | Description of method results of types accessibleto 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 theWHERE clause of a materialized view accessible to the user |
ALL_MVIEW_KEYS | Description of the columns that appear in the GROUP BYlist 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 forrefresh |
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 theWHERE clause of a materialized view accessible to dba |
DBA_MVIEW_KEYS | Description of the columns that appear in the GROUP BYlist 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 |
相关推荐
数据字典 T+16.0数据字典数据字典数据字典数据字典
U8数据字典
用友U8V12.0数据字典是一份详尽的数据库参考文档,专为开发和管理用友U8系统的数据库程序设计。这份资料以CHM(Compiled HTML Help)格式提供,包含了系统中的所有关键组件,如存储过程、表、视图和函数,为开发者...
1. **主动数据字典**:这种类型的数据字典能够自动更新其内容,当数据库或应用程序结构发生变化时,DBMS(数据库管理系统)会自动更新数据字典的相关信息。 2. **被动数据字典**:与主动数据字典相反,被动数据字典...
《用友U8-12.5版本数据字典》是针对企业信息化管理软件用友U8系统的一个重要参考资料,它详细记录了该系统数据库中的各个数据表结构、字段信息及其实用功能,旨在为用户提供数据库查询、系统维护以及二次开发的有力...
1. **数据字典的定义**:数据字典是系统设计中的一个重要组成部分,它提供了关于数据的信息,包括数据项、数据结构、数据流、数据存储和处理过程的详细定义。它是系统分析员和程序员用于理解和管理数据的工具。 2. ...
致远协同V8.0SP1数据字典是 致远协同平台的一个重要组件,它提供了一个统一的数据存储和管理机制,能够满足企业级应用的需求。本数据字典涵盖了致远协同V8.0SP1的数据结构和格式,包括 ADDRESSBOOK 表的设计和实现。...
数据字典是数据库管理系统中的一个重要组成部分,它详细记录了数据库中所有对象的详细信息,包括数据表、字段、索引、视图等。在“NCC1909数据字典”中,我们可以预见到这将是一个关于NCC组织在1909年使用的特定数据...
1. **数据表**:这是数据字典的基本单位,代表系统中的一个存储结构,如员工信息表、项目信息表等。每个数据表都由一组相关的字段组成,用于存储特定类型的信息。 2. **字段**:字段是数据表中的最小单元,表示一个...
1. **数据定义清晰**:数据字典定义了每个数据项的含义、来源、用途,确保所有用户对同一数据的理解一致,避免因理解差异引发的错误。 2. **数据标准化**:通过设定统一的数据格式和编码规则,使数据具有可比性和...
1. 数据字典概述: 数据字典是系统设计阶段的产物,它记录了系统中的所有数据元素,包括数据项、数据结构、数据流、数据存储以及处理过程等。在金蝶K3中,数据字典用于规范和管理系统的数据,确保数据的一致性和...
1. 数据元素:数据字典的核心是数据元素,每个元素代表了系统中的一个具体信息单元,如客户ID、产品名称等。在NC6.X中,数据元素具有明确的名称、类型、长度、小数位数等属性,这些定义了数据的基本特征。 2. 属性...
在信息技术领域,数据字典是系统设计中不可或缺的一部分,它提供了关于数据库结构、字段、数据类型等关键信息的详细描述。对于企业级ERP(Enterprise Resource Planning)系统,如U9 6.0,数据字典的重要性更是...
数据字典查看工具是数据库管理和维护中的重要辅助软件,它为用户提供了一个直观、便捷的方式来查看和理解数据库的结构和内容。在IT行业中,数据字典是数据库设计和管理中的核心部分,它包含了数据库中所有对象的详细...
1. **字段解释**:每个字段都有其特定的含义,例如,一个订单表中可能有“订单号”、“客户ID”、“商品编码”等字段,数据字典会解释这些字段代表什么,如何使用,以及它们之间的关联关系。 2. **数据类型**:数据...
1. **数据实体**:这是数据字典中最基本的元素,通常对应于数据库中的表或视图。数据实体包含了组织内部的各种业务对象,如员工信息、项目信息、文档资料等。 2. **数据项**:数据实体由若干个数据项组成,每个数据...
1. 表格结构:NC6.5的数据字典详细列出了系统中每个表格的结构,包括表格ID、名称、描述以及与之相关的其他表格。这些信息有助于理解数据之间的关联和流转,为数据库设计和优化提供依据。 2. 字段定义:每个表格...
综上所述,用友ERP-U8 v11.0数据字典是一个全面且深入的系统指南,它涵盖了系统的每一个数据层面,为企业提供了高效、规范和安全的数据管理基础。通过深入学习和利用这个数据字典,用户可以更好地掌握系统,提升工作...
泛微ECOLOGY9是一款企业级协同办公系统,它的数据字典是系统中非常关键的部分,用于定义和管理系统的各种数据结构和业务规则。数据字典通常包含了一系列的数据项、数据类型、数据来源、数据权限以及相关的业务逻辑,...