Oracle Common Questions 1000 Questions (Nine)

xiaoxiao2021-03-06  149

801. All_dim_hierarchies

Show the level of dimension.

802. All_dim_join_Key

Describe the connection between the two dimensions.

803. All_dim_level_key

Describe the column of the dimension.

804. All_dim_levels

Describe the dimension level.

805. All_dimensions

Information containing dimensional objects.

806. All_directories

All directory descriptions for users can access.

807. All_ERRORS

The user can access the current error on all objects.

808. all_external_tables

Users can access external tables.

809. All_histograms

Is equal to all_tab_histograms alias.

810. all_ind_columns

User can access index columns.

811. all_ind_expressions

Users can access the function index expression on the table.

812. All_ind_Partitions

To the index partition, describe partition information of the partition level.

813. All_ind_subpartitons

Describe the partition information of the sub-partition level for the index sub-partition.

814. All_indexes

The index description of the user can access.

815. All_indextype_commnets

Users can access user-defined index types.

816. All_indextype_operators

Displays all operators supported by the index type.

817. All_indextypes

Displays all index types.

818. all_internal_triggers

The internal trigger that the user can access.

819. All_JOBS

All jobs in the database.

820. all_join_ind_columns

Describe the connection criteria that you access the bit image connection index.

821. All_libraries

Users can access all libraries.

822. All_lob_Partitions

The user can access the table contains LOB.

823. All_lob_subpartitions

Display the partition level of the LOB data sub-partition.

824. All_lobs

The user can access the table contains LOB.

825. All_log_group_columns

Users can access columns defined in the log group.

826. All_log_groups

The log group definition on the table can be accessed.

827. All_method_Params

Method parameters of the user accessible type.

828. All_Method_Results

The method of user accessibility type.

829. ALL_MVIEW_AGGREGATES

The group function appearing in the SELECT list of the materialization view of the total class.

830. All_mview_analysis

Description Possible to support queries and non-static. Rewrite and have an ingredient view of additional information available for application analysis, but does not include far

831. ALL_MVIEW_DETAIL_RELATIONS

Describe the naming detail relationship of the materialized view from the list of the property, or indirectly by the FROM list.

832. All_mview_joins

Describe the two columns between the physicalized view WHERE clause.

833. ALL_MVIEW_KEYS

Describe the naming detail relationship of the materialized view from the list of the property, or indirectly by the FROM list.

834. ALL_MVIEW_REFRESH_TIMES

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

835. All_mviews

All materialized views for users can access.

836. all_nested_tables

The nested table in the table can be accessed.

837. All_Object_Tables

The description of the user accessible object table.

838. All_opancillary

Display the auxiliary information of the operator.

839. ALL_OPARGUMENTS

Displays the change of the operation bundle.

840. All_opbindings

The display operator is bundled.

841. All_operator_comments

All comments for user accessible user-defined operations.

842. All_operators User Acquisition Operator.

843. All_outline_HINTS

A prompt for user accessible profiles.

844. All_outlines

All of users can access.

845. all_part_col_statistics

The user can access column statistics and histogram information of the table partition.

846. All_part_histograms

The cylindrical data of the user can access the table partition.

847. All_part_indexes

Object-level partition information of all partition index currently accessible.

848. all_part_key_columns

The partition key value of the current user accessible partition object.

849. All_Part_lobs

Table-level information of the current user accessible partition LOB.

850. all_part_tables

Object-level partition information for the current user accessible partition table.

851. all_partial_drop_tabs

The current user can access the table with a local delete table.

852. All_Policies

All strategies on all tables and views of the current user can access.

853. All_Procedures

List all functions and procedures and related properties.

854. All_published_columns

Describe the source list columns that the user has privilege.

855. all_queue_tables

All queues of the current user accessible queue table.

856. All_Queues

Shows the queue information that the user has a team or out of the privilege.

857. All_Refresh

All refresh groups currently accessible can be accessed.

858. All_refresh_Children

List all objects in the refresh group.

859. All_refresh_dependencies

Displays the dependent detail or container table name of all summary or snapshots in the current mode.

860. All_refs

The current user can access the REF column and the REF attribute in the object type column.

861. All_registered_mviews

All materialized views of current users can access.

862. All_registered_snapshots

List all registered snapshots.

863. All_Sequences

All sequences of current users can access.

864. All_Snapshot_logs

The current user accessible materialized view log.

865. all_snapshot_refresh_times

Snapshot refresh number.

866. All_Source

The text source of all storage objects that currently accessible.

867. all_source_tables

Allow the issuer to view all existing source tables.

868. all_sqlj_type_attrs

The current user can access all properties about the SQLJ object.

869. All_SQLJ_TYPE_METHODS

Type method of current user accessible.

870. all_sqlj_types

The current user can access about SQLJ object type information.

871. All_Stored_Settings

The current user has its permanent parameter setting for the storage PL / SQL unit that performs privileges.

872. All_subpart_col_statistics

The column statistics and column information containing user_tab_columns.

873. All_subpart_histograms

Displays the actual histogram information of the histogram of the histogram of the sheet partition.

874. All_Subpart_Key_Columns

The sub-zone key value of the table using the composite range / hash method partition is displayed.

875. All_subscribed_columns

Allow the issuer to view the columns of all the issued issues they are ready.

876. all_subscribed_tables

Allow the issuer to view all the issues they are ready.

877. All_subscriptions

Allow the issuer to view all of them all.

878. All_sumdelia

User accessible direct path loading entries.

879. All_Synonyms

All synonyms for users can access.

880. all_tab_col_statistics

A column statistics and column information containing all_tab_columns.

881. All_tab_columns

Users can access all tables, views, and columns of the aggregation. 882. All_Tab_Comments

Users can access the comments in the tables and views of the view.

883. All_tab_histograms

Users can access column information in the tables and views of the view.

884. All_tab_modifications

The user can access the last statistically modified table.

885. All_Tab_Privs

List the authorizations on the object, the user or public user is awarded.

886. All_TAB_PRIVS_MADE

List the authorization of the user's license and user objects.

887. All_Tab_Privs_Recd

List the authorizations on the object, users and public are granted.

888. All_tab_subpartitions

The user can access the name, storage attribute, the table and partition name it belongs.

889. ALL_TABLES

Description of the user accessible relational table.

890. All_Triggers

The trigger owned by the user.

891. All_trigger_cols

The columns and usages of the triggers owned by the user.

892. All_Type_attrs

The properties of the user accessible type.

893. ALL_TYPE_METHODS

The method of user accessibility type.

894. All_Types

User can access type.

895. All_unused_col_tabs

Contains all tables that are not used.

896. All_updatable_columns

A description of all columns that can be modified in the Mo Connection view.

897. ALL_USERS

Information for all users in the database.

898. All_USTATS

User-user-defined statistics can be accessed.

899. All_Varrays

Users can access all arrays.

900. All_views

Users can access text.

Oracle9i's data dictionary

转载请注明原文地址:https://www.9cbs.com/read-127659.html

New Post(0)