Oracle Common Fool question 1000 question (12)

Source: Internet
Author: User
Tags definition comments contains hash log
Oracle
Oracle Common fool question 1000 Q (12)



Author: ccbzzp



9I managed data dictionary all view.



783. All_all_tables

All tables accessible to the user.

784. all_arguments

All the parameters of the object that the user can access.

785. all_associations

User-defined statistics.

786. All_base_table_mviews

All materialized view information accessible to the user.

787. All_catalog

All tables, synonyms, viewport and sequences accessible to the user.

788. all_cluster_hash_expressions

User-accessible aggregate hash function.

789. all_clusters

All aggregation that the user can access.

790. all_col_comments

Comments on tables or views accessible to the user.

791. All_col_privs

Lists the authorizations on the column, and the user or public is the grantee.

792. All_col_privs_made

Lists the authorizations on the column, and the user is the owner or the authorized person.

793. All_col_privs_recd

Lists the authorizations on the column, and the user or public is the authorized person.

794. All_coll_types

The named collection type that the user can access.

795. All_cons_columns

Contains information that is accessible to columns in a constraint definition.

796. all_constraints

Lists the constraint definitions on an accessible table.

797. All_context

Displays the up and down information for the activity.

798. All_db_links

A data link that is accessible to the user.

799. all_def_audit_opts

Contains the default object auditing options that are applied when an object is established.

All_dependencies.

Dependencies between objects that are accessible to users.

801. all_dim_hierarchies

Displays the level of the dimension.

All_dim_join_key

Describes the connection between two dimensions.

803. All_dim_level_key

Describes the dimension-level columns.

804. All_dim_levels

Describes the dimension level.

805. all_dimensions

Contains information about the dimension object.

806. all_directories

Description of all directories accessible to the user.

807. All_errors

The current error on all objects accessible to the user.

808. All_external_tables

The external table that the user can access.

809. All_histograms

equals All_tab_histograms alias.

810. All_ind_columns

The indexed columns that the user can access.

811. All_ind_expressions

A functional index expression on a table accessible to the user.

812. all_ind_partitions

is an index partition that describes partition information at the partition level.

813. all_ind_subpartitons

is an index child partition that describes the partition information for the child partition level.

814. all_indexes

The index description on the table accessible to the user.

815. All_indextype_commnets

User-defined index types that the user can access.

816. all_indextype_operators

Displays all the operators supported by the index type.

817. All_indextypes

All index types are displayed.

818. All_internal_triggers

An internal trigger that the user can access.

819. All_jobs

All jobs in the database.

820. All_join_ind_columns

Describes the join conditions for the bit Map connection index you are accessing.

821. all_libraries

All libraries that the user can access.

822. all_lob_partitions

The table that the user can access contains lobs.

823. all_lob_subpartitions

Displays the partition level of the LOB data child partitions.

824. All_lobs

The table that the user can access contains lobs.

825. All_log_group_columns

A user-accessible column defined in a log group.

826. all_log_groups

The log group definition on the table that the user can access.

827. All_method_params

The method parameters of the type that the user can access.

828. All_method_results

The method result of the type that the user can access.

829. all_mview_aggregates

The grouping function that appears in the select list of the materialized view of the aggregate class.

830. all_mview_analysis

Describes materialized views that may support query rewriting and additional information that can be used for application profiling, but not remote and non-static.

831. all_mview_detail_relations

Describes the naming details relationships that are in the materialized view from list or are indirectly referenced by views in the From list.

832. All_mview_joins

Describes the connection between two columns in a materialized view where clause.

833. All_mview_keys

Describes the naming details relationships that are in the materialized view from list or are indirectly referenced by views in the From list.

834. All_mview_refresh_times

The refresh time of the materialized view that the user can access.

835. all_mviews

All materialized views that the user can access.

836. All_nested_tables

A nested table in a table that is accessible to the user.

837. All_object_tables

A description of the object table that the user can access.

838. All_opancillary

Displays auxiliary information for the operator.

839. all_oparguments

Displays the meta information for the operator bundle.

840. all_opbindings

Displays operator bindings.

841. all_operator_comments

All annotations of user-defined actions that are accessible to the user.

842. all_operators

User-accessible operator.

843. all_outline_hints

Tips for user-accessible profiles.

844. All_outlines

All profiles accessible to the user.

845. All_part_col_statistics

Column statistics and histogram information for the table partitions that the user can access.

846. All_part_histograms

Column data for table partitions accessible to the user.

847. all_part_indexes

Object-level partition information for all partitioned indexes accessible to the current user.

848. All_part_key_columns

The partition key value of the partition object that the current user can access.

849. All_part_lobs

Table-level information for the partition lob that the current user can access.

850. all_part_tables

Object-level partition information for the partitioned table that the current user can access.

851. All_partial_drop_tabs

A table in which the current user can access a locally deleted table.

852. all_policies

All the policies on all tables and views accessible to the current user.

853. All_procedures

Lists all of the functions and procedures and related properties.

854. All_published_columns

A source table column that describes the existence of a privileged user.

855. All_queue_tables

All queues for the queue table that the current user can access.

856. all_queues

Displays queue information for which the user has team or outbound privileges.

857. All_refresh

All refresh groups that the current user can access.

858. All_refresh_children

Lists all objects in the refresh group.

859. all_refresh_dependencies

Displays dependency details or container table names for all profiles or snapshots in the current pattern.

860. All_refs

The ref and REF attributes in the object type column that the current user can access.

861. All_registered_mviews

All materialized views accessible to the current user.

862. All_registered_snapshots

Lists all registered snapshots.

863. all_sequences

All the sequences that the current user can access.

864. All_snapshot_logs

Materialized view logs accessible to the current user.

865. All_snapshot_refresh_times

The number of snapshot refreshes.

866. All_source

The text source for all storage objects that the current user can access.

867. All_source_tables

Allows publishers to view all existing source tables.

868. All_sqlj_type_attrs

All properties about the Sqlj object that the current user can access.

869. All_sqlj_type_methods

The type method that the current user can access.

870. All_sqlj_types

Information about the Sqlj object type that the current user can access.

871. all_stored_settings

The permanent parameter setting for the storage Pl/sql unit for which the current user has executive privileges.

872. All_subpart_col_statistics

Contains column statistics and columnar information for user_tab_columns.

873. All_subpart_histograms

Displays the actual histogram information for a columnar chart in a table sub partition.

874. All_subpart_key_columns

Displays the child partition key values for the table that uses the compound range/hash method partition.

875. All_subscribed_columns

Allows publishers to view all published columns that they have scheduled.

876. All_subscribed_tables

Allow publishers to view all published tables they have scheduled.

877. all_subscriptions

Allow publishers to view all their bookings.

878. All_sumdelia

User-accessible direct path mount entry.

879. all_synonyms

All synonyms that the user can access.

880. All_tab_col_statistics

Contains column statistics and columnar information for all_tab_columns.

881. All_tab_columns

All tables, views, and clustered columns that the user can access.

882. all_tab_comments

Comments in tables and views that are accessible to users.

883. All_tab_histograms

column information in tables and views that users can access.

884. All_tab_modifications

A table that has been modified since the last statistic that the user can access.

885. All_tab_privs

Lists the authorizations on the object, and the user or public user is the grantee.

886. All_tab_privs_made

Lists the authorization for the user and the authorization on the user object.

887. All_tab_privs_recd

Lists the authorization on the object, and the user and public are the grantee.

888. all_tab_subpartitions

The name of each table sub partition that the user can access, the storage attribute, the table and partition name to which it belongs.

889. All_tables

Description of the user-accessible relational table.

890. all_triggers

User-owned triggers.

891. All_trigger_cols

The column and usage of a user-owned trigger.

892. All_type_attrs

The properties of the type that the user can access.

893. All_type_methods

Methods of user-accessible types.

894. All_types

The type that the user can access.

895. All_unused_col_tabs

Contains all tables that do not use columns.

896. All_updatable_columns

Contains descriptions of all the columns that can be modified in the MO-connected view.

897. All_users

Information for all users in the database.

898. All_ustats

User-defined statistics that users can access.

899. All_varrays

All arrays that the user can access.

900. All_views

The text of the view that the user can access.



Cond...






Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.