Overblog Suivre ce blog
Editer la page Administration Créer mon blog
/ / /

Les Vues ALL du dictionnaire de données (vues systèmes) décrivent les objets de l'Utilisateur et les Objets pour lesquels il a des droits d'accès. 

SQL> SELECT table_name,
            comments
     FROM dictionary
     WHERE table_name like 'ALL%'
     ORDER BY table_name;



NOM

DESCRIPTION

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_ENQUEUE Details about the apply enqueue action for user accessible rules where the destination queue exists and is visible to the user
ALL_APPLY_ERROR Error transactions that were generated after dequeuing from the queue visible to the current user
ALL_APPLY_EXECUTE Details about the apply execute action for all rules visible to the 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_APPLY_TABLE_COLUMNS Details about the columns of destination table object visible to the 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_AUDIT_POLICY_COLUMNS All fine grained auditing policy columns in the database
ALL_AWS Analytic Workspaces accessible to the user
ALL_AW_AC Active Catalog Analytic Workspaces accessible to the user
ALL_AW_AC_10G  
ALL_AW_OBJ Objects in Analytic Workspaces accessible to the user
ALL_AW_PROP Object properties in Analytic Workspaces accessible to the user
ALL_AW_PROP_NAME Analytic Workspace property names accessible to the user
ALL_AW_PS Pagespaces in Analytic Workspaces accessible to the user
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_EXTRA_ATTRIBUTES Extra attributes for a capture process that is 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_DEQUEUE_QUEUES All queues 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_ENCRYPTED_COLUMNS Encryption information on all accessible columns
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_FILE_GROUPS Details about file groups
ALL_FILE_GROUP_EXPORT_INFO Details about export information of file group versions
ALL_FILE_GROUP_FILES Details about file group files
ALL_FILE_GROUP_TABLES Details about the tables in the file group repository
ALL_FILE_GROUP_TABLESPACES Details about the transportable tablespaces in the file group repository
ALL_FILE_GROUP_VERSIONS Details about file group versions
ALL_HISTOGRAMS Synonym for ALL_TAB_HISTOGRAMS
ALL_INDEXES Descriptions of indexes on tables accessible to the user
ALL_INDEXTYPES All indextypes available to the user
ALL_INDEXTYPE_ARRAYTYPES All array types specified by the indextype
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_STATISTICS Optimizer statistics for all indexes on tables accessible to the user
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_JOBS Synonym for USER_JOBS
ALL_JOIN_IND_COLUMNS Join Index columns comprising the join conditions
ALL_LIBRARIES Description of libraries accessible to the user
ALL_LOBS Description of LOBs contained in tables accessible to the user
ALL_LOB_PARTITIONS  
ALL_LOB_SUBPARTITIONS  
ALL_LOB_TEMPLATES  
ALL_LOG_GROUPS Log group definitions on accessible tables
ALL_LOG_GROUP_COLUMNS Information about columns in log group definitions
ALL_METHOD_PARAMS Description of method parameters of types accessible to the user
ALL_METHOD_RESULTS Description of method results of types accessible to the user
ALL_MVIEWS All materialized views in the database
ALL_MVIEW_AGGREGATES Description of the materialized view aggregates accessible to the user
ALL_MVIEW_ANALYSIS Description of the materialized views accessible to the user
ALL_MVIEW_COMMENTS Comments on materialized views accessible to the user
ALL_MVIEW_DETAIL_RELATIONS Description of the materialized view detail tables accessible to the user
ALL_MVIEW_JOINS Description of a join between two columns in the WHERE clause of a materialized view accessible to the user
ALL_MVIEW_KEYS Description of the columns that appear in the GROUP BY list of a materialized view accessible to the user
ALL_MVIEW_LOGS All materialized view logs in the database that the user can see
ALL_MVIEW_REFRESH_TIMES Materialized views and their last refresh times for each master table that the user can look at
ALL_NESTED_TABLES Description of nested tables in tables accessible to the user
ALL_NESTED_TABLE_COLS Columns of nested tables
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_OLAP_ALTER_SESSION Synonym for V$OLAP_ALTER_SESSION
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_OUTLINES Synonym for USER_OUTLINES
ALL_OUTLINE_HINTS Synonym for USER_OUTLINE_HINTS
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_PLSQL_OBJECT_SETTINGS Compiler settings of stored objects accessible to the user
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 Source columns available for Change Data Capture
ALL_QUEUES All queues accessible to the user
ALL_QUEUE_PUBLISHERS  
ALL_QUEUE_SUBSCRIBERS All queue subscribers accessible to user
ALL_QUEUE_TABLES All queue tables accessible to the user
ALL_REFRESH All the refresh groups that the user can touch
ALL_REFRESH_CHILDREN All the objects in refresh groups, where the user can touch the group
ALL_REFRESH_DEPENDENCIES Description of the detail tables that materialized views depend on for refresh
ALL_REFS Description of REF columns contained in tables accessible to the user
ALL_REGISTERED_MVIEWS Remote materialized views of local tables that the user can see
ALL_REGISTERED_SNAPSHOTS Remote snapshots of local tables that the user can see
ALL_REGISTRY_BANNERS  
ALL_REPAUDIT_ATTRIBUTE Information about attributes automatically maintained for replication
ALL_REPAUDIT_COLUMN Information about columns in all shadow tables for replicated tables which are accessible to the user
ALL_REPCAT  
ALL_REPCATLOG Information about asynchronous administration requests
ALL_REPCOLUMN Replicated top-level columns (table) sorted alphabetically in ascending order
ALL_REPCOLUMN_GROUP All column groups of replicated tables which are accessible to the user
ALL_REPCONFLICT All conflicts with available resolutions for user's replicated tables
ALL_REPDDL Arguments that do not fit in a single repcat log record
ALL_REPFLAVORS Flavors defined for replicated object groups
ALL_REPFLAVOR_COLUMNS Replicated columns in flavors
ALL_REPFLAVOR_OBJECTS Replicated objects in flavors
ALL_REPGENERATED Objects generated to support replication
ALL_REPGENOBJECTS Objects generated to support replication
ALL_REPGROUP Information about replicated object groups
ALL_REPGROUPED_COLUMN Columns in the all column groups of replicated tables which are accessible to the user
ALL_REPGROUP_PRIVILEGES Information about users who are registered for object group privileges
ALL_REPKEY_COLUMNS Primary columns for a table using column-level replication
ALL_REPOBJECT Information about replicated objects
ALL_REPPARAMETER_COLUMN All columns used for resolving conflicts in replicated tables which are accessible to the user
ALL_REPPRIORITY Values and their corresponding priorities in all priority groups which are accessible to the user
ALL_REPPRIORITY_GROUP Information about all priority groups which are accessible to the user
ALL_REPPROP Propagation information about replicated objects
ALL_REPRESOLUTION Description of all conflict resolutions for replicated tables which are accessible to the user
ALL_REPRESOLUTION_METHOD All conflict resolution methods accessible to the user
ALL_REPRESOLUTION_STATISTICS Statistics for conflict resolutions for replicated tables which are accessible to the user
ALL_REPRESOL_STATS_CONTROL Information about statistics collection for conflict resolutions for replicated tables which are accessible to the user
ALL_REPSCHEMA N-way replication information
ALL_REPSITES N-way replication information
ALL_REWRITE_EQUIVALENCES Description of all rewrite equivalence accessible to the user
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_SCHEDULER_CHAINS All scheduler chains in the database visible to current user
ALL_SCHEDULER_CHAIN_RULES All rules from scheduler chains visible to the current user
ALL_SCHEDULER_CHAIN_STEPS All steps of scheduler chains visible to the current user
ALL_SCHEDULER_GLOBAL_ATTRIBUTE All scheduler global attributes
ALL_SCHEDULER_JOBS All scheduler jobs visible to the user
ALL_SCHEDULER_JOB_ARGS All arguments with set values of all scheduler jobs in the database
ALL_SCHEDULER_JOB_CLASSES All scheduler classes visible to the user
ALL_SCHEDULER_JOB_LOG Logged information for all scheduler jobs
ALL_SCHEDULER_JOB_RUN_DETAILS The details of a job run
ALL_SCHEDULER_PROGRAMS All scheduler programs visible to the user
ALL_SCHEDULER_PROGRAM_ARGS All arguments of all scheduler programs visible to the user
ALL_SCHEDULER_RUNNING_CHAINS All job steps of running job chains visible to the user
ALL_SCHEDULER_SCHEDULES All schedules in the database
ALL_SCHEDULER_WINDOWS All scheduler windows in the database
ALL_SCHEDULER_WINDOW_DETAILS The details of a window
ALL_SCHEDULER_WINDOW_GROUPS All scheduler window groups in the database
ALL_SCHEDULER_WINDOW_LOG Logged information for all scheduler windows
ALL_SCHEDULER_WINGROUP_MEMBERS Members of all scheduler window groups in the database
ALL_SECONDARY_OBJECTS All secondary objects for domain indexes
ALL_SEC_RELEVANT_COLS Security Relevant columns of all VPD policies for tables or views which the user has access
ALL_SEQUENCES Description of SEQUENCEs accessible to the user
ALL_SERVICES  
ALL_SNAPSHOTS Snapshots the user can access
ALL_SNAPSHOT_LOGS All snapshot logs in the database that the user can see
ALL_SNAPSHOT_REFRESH_TIMES Synonym for ALL_MVIEW_REFRESH_TIMES
ALL_SOURCE Current source on stored objects that user is allowed to create
ALL_SOURCE_TABLES Source tables available for Change Data Capture
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_SQLSET  
ALL_SQLSET_BINDS  
ALL_SQLSET_PLANS  
ALL_SQLSET_REFERENCES  
ALL_SQLSET_STATEMENTS  
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_MESSAGE_CONSUMERS Streams messaging consumers visible to the current user
ALL_STREAMS_MESSAGE_RULES Rules for Streams messaging visible to the current user
ALL_STREAMS_NEWLY_SUPPORTED List of tables that are newly supported by Streams
ALL_STREAMS_RULES Rules used by streams processes
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_STREAMS_TRANSFORM_FUNCTION Rules-based transform functions used by Streams
ALL_STREAMS_UNSUPPORTED List of all the tables that are not supported by Streams in this release
ALL_SUBPARTITION_TEMPLATES  
ALL_SUBPART_COL_STATISTICS  
ALL_SUBPART_HISTOGRAMS  
ALL_SUBPART_KEY_COLUMNS  
ALL_SUBSCRIBED_COLUMNS Change Data Capture subscribed columns
ALL_SUBSCRIBED_TABLES Change Data Capture subscribed tables
ALL_SUBSCRIPTIONS Change Data Capture 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 for base objects accessible to the user and session
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_STATISTICS Optimizer statistics for all tables accessible to the user
ALL_TAB_STATS_HISTORY History of table statistics modifications
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_WARNING_SETTINGS Warnings ettings for objects accessible to the user
ALL_WORKSPACES  
ALL_XML_INDEXES Description of the all XMLType indexes that the user has privileges on
ALL_XML_SCHEMAS Description of all XML Schemas that user has privilege to reference
ALL_XML_SCHEMAS2 Dummy version of ALL_XML_SCHEMAS that does not have an XMLTYPE column
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


Partager cette page

Repost 0
Published by