Oracle Oracle Common Fool question 1000 question (11)
Author: ccbzzp
9I managed data Dictionary user view.
645. User_all_tables
Contains a description of the tables available to the user.
646. user_arguments
Lists the parameters in the object that can be accessed by the user.
647. User_associations
User-defined statistics for related objects owned by the current user.
648. User_audit_object
Statement audit trail for an object.
649. user_audit_session
A full audit trail of user connections or disconnects.
650. user_audit_statement
Lists the audit trail entries for the Grant,revoke,audit,noaudit,alter system statement issued by the user.
651. User_audit_trail
User-related audit trail entries.
652. User_base_table_mviews
All materialized views owned by the current user that use materialized view logs.
653. User_catalog
User-owned tables, views, synonyms, and sequences.
654. User_clu_columns
The mapping of the columns of the user table to the clustered column.
655. user_cluster_hash_expressions
All aggregation and hash functions that the user can access.
656. User_clusters
Description of the aggregation that the user owns.
657. user_col_comments
Lists the comments on the columns of the user table or view.
658. User_col_privs
Lists the authorizations on the column, and the user is the owner, the grantee, or the grantee.
659. User_col_privs_made
Lists all the authorizations on the column that the user owns the object.
660. User_col_privs_recd
Lists the authorization on the column, and the user is the grantee.
661. User_coll_types
The named collection type of the user.
662. User_cons_columns
The column information in the user-owned constraint definition.
663. user_constraints
The constraint definition on the user table.
664. User_db_links
Database chain information.
665. user_dependencies
Dependencies between the objects of the user.
666. User_dim_attributes
The relationship between the current user-mode-level and functional dependencies.
667. user_dim_child_of
The current user-owned hierarchical relationship of 1 to n-dimensional levels.
668. user_dim_hierarchies
The level of the dimension that the current user owns.
669. User_dim_join_key
The connection between the dimensions owned by the current user.
670. User_dim_level_key
A dimension-level column owned by the current user.
671. User_dim_levels
A dimension column owned by the current user.
672. User_dimensions
The current user-mode lower-dimensional object.
673. User_errors
The current error on all storage objects for the user.
674. user_extents
The range of segments that belong to the user object.
675. User_external_tables
All external objects owned by the current user.
676. User_free_space
The user can access the free range in the table space.
678. User_histograms
This view is a synonym for user_histograms.
679. User_ind_columns
User indexes and columns on the table.
680. User_ind_expressions
An expression of a function-based index on a table owned by the current user.
681. user_ind_subpartitions
The attributes of each character partition that the current user owns, partition-level partition information, the storage parameters of the sub partition, the various points of the Analyze decision
District statistics.
682. user_indexes
The description of the index owned by the current user.
683. user_indextype_comments
All comments for the user-defined index type owned by the current user.
684. user_indextype_operators
All operations for the index type owned by the current user.
685. User_indextypes
All index types owned by the current user.
686. User_internal_triggers
Internal triggers on all tables owned by the current user.
687. User_jobs
All jobs owned by the user.
688. User_join_ind_columns
All connection conditions in the database owned by the current user.
689. User_libraries
Lists all the libraries owned by the user.
690. User_lob_partitions
The partition-level attributes in the LOB data child partitions owned by the current user.
691. User_lobs
Displays the lob contained in the user table.
692. User_log_group_columns
The column that the current user has specified in the log.
693. user_log_groups
The log group definition for all tables owned by the current user in the database.
694. User_method_params
The method parameter of the user type owned by the current user.
695. User_mview_aggregates
The grouping function that is present in the select list of the clustered materialized view owned by the current user.
696. user_mview_analysis
All materialized views owned by the current user are used to potentially support query rewriting and have additional information that can be used for application analysis.
697. user_mview_detail_relations
Represents a naming detail relationship.
698. User_mview_joins
Describes the connection between two columns in a WHERE clause of a materialized view.
699. User_mview_keys
The materialized view is based on the current user-mode column or expression in the select list.
User_mview_refresh_times.
The refresh time for all materialized views owned by the current user in the database.
701. User_mviews
All materialized views owned by the current user in the database.
702. user_nested_tables
A nested table in a table owned by the current user.
703. user_obj_audit_opts
Auditing options for tables and views owned by the user.
704. user_object_size
The size of the Pl/sql object that the user owns.
705. User_object_tables
The object table owned by the user.
706. User_object
The object that the user owns.
707. user_opancillary
Auxiliary information for operations owned by the current user.
708. user_oparguments
Argument information for operations owned by the current user.
709. user_opbindings
The binding of the operation owned by the current user.
710. user_operator_comments
All comments for user-defined actions owned by the current user.
711. User_operators
All operations owned by the current user.
712. user_outline_hints
The implied setting of the composition profile currently owned by the user.
713. User_outlines
All profiles owned by the current user.
714. User_part_col_statistics
Column statistics and histogram data for table partitions owned by the current user.
715. User_part_histograms
Column chart data on table partitions accessible to the current user.
716. User_part_key_columns
The partition key column of the partition object owned by the current user.
717. user_part_indexes
All object-level partition information for all partitions owned by the current user.
718. User_part_lobs
Table-level information for partitioned large objects owned by the current user.
719. User_part_tables
The object-level partition information for the partition table owned by the current user.
720. User_partial_drop_tabs
All tables in the current user mode that have partial delete table operations.
721. user_password_limits
The password parameter file assigned to the user.
722. user_policies
The security policy for all objects owned by the current user.
723. User_procedures
All the functions and faults owned by the current user and their associated properties.
724. user_proxies
The connection information that the current user is allowed to broker.
725. User_published_columns
Describes all existing source table columns that are privileged.
726. User_queue_schedules
Information about the queue schedule.
727. User_queue_tables
Describes only queues in a queue table created in user mode.
728. user_queues
All refresh groups for each queue in user mode.
729. User_refresh
All refresh groups owned by the current user.
730. User_refresh_children
Lists all objects in the refresh group.
731. User_refs
The ref and REF attributes in the object type column of the user table.
732. User_registered_mviews
All registered materialized views owned by the current user.
733. User_registered_snapshots
All registered snapshots owned by the current user.
734. User_resource_limits
The resource limit for the current user.
735. user_resumable
Lists the recoverable statements executed by the current user.
736. User_rols_privs
Lists the roles that are granted to the user.
737. User_rsrc_consumer_group_privs
Lists all resource consumption groups that are granted to the user.
738. User_rsrc_manager_system_privs
Lists all users who have been granted system privileges for the Dbms_resource_manager package.
739. user_segments
Lists the storage allocation information for the database segments that belong to the user object.
740. user_sequences
Description of the user sequence.
741. User_snapshot_logs
All snapshot logs owned by the user.
742. User_snapshot_refresh_times
The number of times the snapshot was refreshed.
743. User_snapshots
Snapshots that users can view.
744. User_source
The text source for all storage objects that belong to the user.
745. User_sorce_tables
Allows you to view all existing source tables with predetermined privileges.
746. User_sqlj_type_attrs
All properties owned by the current user about the Sqlj object.
747. User_sqlj_type_methods
The type method owned by the current user.
748. User_sqlj_types
Information about the Sqlj object type owned by the current user.
749. user_stored_settings
The permanent parameter setting for the stored Pl/sql cell owned by the current user.
750. User_subpart_col_statistics
Displays column statistics and histogram information for the child partitions of a child partition object owned by the current user.
751. User_subpart_histograms
Displays the actual histogram data for the histogram in the table sub partition owned by the current user.
752. User_subpart_key_columns
Displays column statistics and histogram information for the child partitions of a child partition object owned by the current user.
753. User_subscribed_columns
Allows the Publisher to view all scheduled published columns.
754. User_subscribed_tables
Allows the Publisher to view all scheduled published tables.
755. user_subscriptions
Allow publishers to view all bookings.
756. user_sysnonyms
Private synonyms owned by the current user.
757. User_sys_privs
System privileges granted to the user.
758. User_tab_col_statistics
Contains column statistics and histogram information in the User_tab_columns view.
759. User_tab_columns
Information about the columns on the user table or view or cluster.
760. user_tab_comments
A user owns a comment on a table or view.
761. User_tab_histograms
A histogram on the column of the user table.
762. User_tab_modifications
All the tables that the user has been modified since they were last counted.
763. user_tab_partitions
The name of each table child that the user owns, the storage attribute, the table and partition name to which it belongs.
764. User_tab_privs
The privilege on the object.
765. User_tab_privs_made
The user owns all the privileges on the object.
766. User_tab_privs_recd
Contains the privileges on the object, and the user is the grantee.
767. User_tab_subpartitions
The name of each child partition that the user owns, the storage attribute, the table to which it belongs, and the name of the partition.
768. User_tables
Description of the relationship table owned by the user.
769. user_tablespaces
A description of the table space that can be accessed.
770. user_transformations
Transformation information that is owned by a particular user.
771. User_trigger_cols
The use of columns in user triggers.
772. User_triggers
Description of the user trigger.
773. User_types
The type of the user in the table.
774. User_type_attrs
The properties of the user's type.
775. User_ts_quotas
The table space limit for the user.
776. User_methods
The user's method type.
777. User_unused_col_tabs
All tables with unused columns are included.
778. User_updatable_columns
A description of the columns that the user can modify in the connection view.
779. user_users
Information for the current user.
780. User_ustats
User-defined statistics that are owned by the user.
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.
