Quantcast

Oracle Sql et administration

Vues ALL du Dictionnaire de données Oracle


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


 

Rechercher

Recherche sur le Site

 

Thèmes Oracle

 

Les Vues V$ ...

 

Erreurs Oracle

 

Oracle 10G - DBA -

 

Syndication

  • Flux RSS des articles

 

Contact - C.G.U. - Rémunération en droits d'auteur - Signaler un abus - Articles les plus commentés