`
yuky1327
  • 浏览: 123493 次
  • 性别: 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
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics