`
yuky1327
  • 浏览: 125078 次
  • 性别: Icon_minigender_2
  • 来自: 广州
社区版块
存档分类
最新评论

数据字典一

阅读更多
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数据字典数据字典数据字典数据字典

    数据字典 T+16.0数据字典数据字典数据字典数据字典

    U8数据字典,U8数据字典,U8数据字典U8数据字典

    U8数据字典

    U8 V12.0数据字典_u813chm字典_U8数据字典_U8字典_用友_用友U8V12.0数据字典_

    用友U8V12.0数据字典是一份详尽的数据库参考文档,专为开发和管理用友U8系统的数据库程序设计。这份资料以CHM(Compiled HTML Help)格式提供,包含了系统中的所有关键组件,如存储过程、表、视图和函数,为开发者...

    数据治理那些事(10)-数据字典1.docx

    1. **主动数据字典**:这种类型的数据字典能够自动更新其内容,当数据库或应用程序结构发生变化时,DBMS(数据库管理系统)会自动更新数据字典的相关信息。 2. **被动数据字典**:与主动数据字典相反,被动数据字典...

    U812.5 数据字典_U8数据库字典_用友数据字典12.5版本_

    《用友U8-12.5版本数据字典》是针对企业信息化管理软件用友U8系统的一个重要参考资料,它详细记录了该系统数据库中的各个数据表结构、字段信息及其实用功能,旨在为用户提供数据库查询、系统维护以及二次开发的有力...

    ecology数据字典.zip

    1. **数据字典的定义**:数据字典是系统设计中的一个重要组成部分,它提供了关于数据的信息,包括数据项、数据结构、数据流、数据存储和处理过程的详细定义。它是系统分析员和程序员用于理解和管理数据的工具。 2. ...

    致远 协同 V8.0SP1 数据字典

    致远协同V8.0SP1数据字典是 致远协同平台的一个重要组件,它提供了一个统一的数据存储和管理机制,能够满足企业级应用的需求。本数据字典涵盖了致远协同V8.0SP1的数据结构和格式,包括 ADDRESSBOOK 表的设计和实现。...

    NCC1909数据字典

    数据字典是数据库管理系统中的一个重要组成部分,它详细记录了数据库中所有对象的详细信息,包括数据表、字段、索引、视图等。在“NCC1909数据字典”中,我们可以预见到这将是一个关于NCC组织在1909年使用的特定数据...

    致远 A6 数据字典

    1. **数据表**:这是数据字典的基本单位,代表系统中的一个存储结构,如员工信息表、项目信息表等。每个数据表都由一组相关的字段组成,用于存储特定类型的信息。 2. **字段**:字段是数据表中的最小单元,表示一个...

    用友PLM Professional 数据字典

    1. **数据定义清晰**:数据字典定义了每个数据项的含义、来源、用途,确保所有用户对同一数据的理解一致,避免因理解差异引发的错误。 2. **数据标准化**:通过设定统一的数据格式和编码规则,使数据具有可比性和...

    金蝶K3数据字典

    1. 数据字典概述: 数据字典是系统设计阶段的产物,它记录了系统中的所有数据元素,包括数据项、数据结构、数据流、数据存储以及处理过程等。在金蝶K3中,数据字典用于规范和管理系统的数据,确保数据的一致性和...

    NC6.X数据字典_633数据字典_nc数据字典_

    1. 数据元素:数据字典的核心是数据元素,每个元素代表了系统中的一个具体信息单元,如客户ID、产品名称等。在NC6.X中,数据元素具有明确的名称、类型、长度、小数位数等属性,这些定义了数据的基本特征。 2. 属性...

    U9 6.0 离线数据字典

    在信息技术领域,数据字典是系统设计中不可或缺的一部分,它提供了关于数据库结构、字段、数据类型等关键信息的详细描述。对于企业级ERP(Enterprise Resource Planning)系统,如U9 6.0,数据字典的重要性更是...

    数据字典查看工具

    数据字典查看工具是数据库管理和维护中的重要辅助软件,它为用户提供了一个直观、便捷的方式来查看和理解数据库的结构和内容。在IT行业中,数据字典是数据库设计和管理中的核心部分,它包含了数据库中所有对象的详细...

    用友NC57数据字典

    1. **字段解释**:每个字段都有其特定的含义,例如,一个订单表中可能有“订单号”、“客户ID”、“商品编码”等字段,数据字典会解释这些字段代表什么,如何使用,以及它们之间的关联关系。 2. **数据类型**:数据...

    OA系统数据字典

    1. **数据实体**:这是数据字典中最基本的元素,通常对应于数据库中的表或视图。数据实体包含了组织内部的各种业务对象,如员工信息、项目信息、文档资料等。 2. **数据项**:数据实体由若干个数据项组成,每个数据...

    NC65数据字典

    1. 表格结构:NC6.5的数据字典详细列出了系统中每个表格的结构,包括表格ID、名称、描述以及与之相关的其他表格。这些信息有助于理解数据之间的关联和流转,为数据库设计和优化提供依据。 2. 字段定义:每个表格...

    用友ERP-U8 v11.0数据字典

    综上所述,用友ERP-U8 v11.0数据字典是一个全面且深入的系统指南,它涵盖了系统的每一个数据层面,为企业提供了高效、规范和安全的数据管理基础。通过深入学习和利用这个数据字典,用户可以更好地掌握系统,提升工作...

    泛微ecology9数据字典明细

    泛微ECOLOGY9是一款企业级协同办公系统,它的数据字典是系统中非常关键的部分,用于定义和管理系统的各种数据结构和业务规则。数据字典通常包含了一系列的数据项、数据类型、数据来源、数据权限以及相关的业务逻辑,...

Global site tag (gtag.js) - Google Analytics