Oracle basics-8

658. user_col_privs
Lists the permissions on a column. The user is the owner, the grantee, or the grantee.
659. user_col_privs_made
Lists All permissions on columns of objects owned by users.
660. user_col_privs_recd
Lists the permissions on a column. The user is the authorized user.
661. user_coll_types
The type of the user's name set.
662. user_cons_columns
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 user objects.
666. user_dim_attributes
The relationship between the dimension level and functional dependency in current user mode.
667. user_dim_child_of
Level 1 to n-dimensional relationships of the current user.
668. user_dim_hierarchies
The dimension level owned by the current user.
669. user_dim_join_key
Connections between dimensions owned by the current user.
670. user_dim_level_key
A dimension column owned by the current user.
671. user_dim_levels
A dimension column owned by the current user.
672. user_dimensions
Dimension object in current user mode.
673. user_errors
Current error on all storage objects of the user.
674. user_extents
The range of user object segments.
675. user_external_tables
All external objects owned by the current user.
676. user_free_space
You can access the free range in the tablespace.
678. user_histograms
This view is a synonym for user_histograms.
679. user_ind_columns
User index and table column.
680. user_ind_expressions
The expression of the function-based index on the table owned by the current user.
681. user_ind_subpartitions
Attributes of each word partition owned by the current user, partition-level partition information, storage parameters of sub-partitions, analyze
Various partition statistics.
682. user_indexes
Description of the index owned by the current user.
683. user_indextype_comments
All comments of the index types defined by the current user.
684. user_indextype_operators
All operations of 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 for all tables owned by the current user.
687. user_jobs
All jobs owned by the user.
688. user_join_ind_columns
All the connection conditions of the database owned by the current user.
689. user_libraries
Lists All databases owned by users.
690. user_lob_partitions
The shard-level attribute in the lob data subpartition owned by the current user.
691. user_lobs
Displays the lob contained in the User table.
692. user_log_group_columns
The column specified in the log owned by the current user.
693. user_log_groups
The log Group Definition of all tables owned by the current user in the database.
694. user_method_params
Method parameters of the user type owned by the current user.
695. user_mview_aggregates
Grouping functions owned by the current user in the select list of the clustered instantiation view.
696. user_mview_analysis
All materialized views owned by the current user are used to potentially support query rewriting and include
Additional information.
697 user_mview_detail_relations
Represents the detailed naming relationship.
698. user_mview_joins
Describes the connection between two columns in a where clause of an instantiated view.
699. user_mview_keys
Materialized view is based on the column or expression of the current user mode in the select list.
700. user_mview_refresh_times
Refresh time of 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
The nested table in the table owned by the current user.
703. user_obj_audit_opts
Audit options for user-owned tables and views.
704. user_object_size
The size of PL/SQL objects owned by the user.
705. user_object_tables
User-owned object table.
706. user_object
Objects owned by the user.
707. user_opancillary
Auxiliary Information of operations owned by the current user.
708. user_oparguments
Argument Information about the operation owned by the current user.
709. user_opbindings
Binding of operations owned by the current user.
710. user_operator_comments
All comments of user-defined operations owned by the current user.
711. user_operators
All operations owned by the current user.
712. user_outline_hints
Sets the summary of the composition of the current user.
713. user_outlines
All profiles owned by the current user.
714. user_part_col_statistics
Column statistics and column chart data of table partitions owned by the current user.
715. user_part_histograms
The column chart data on the table partition that the current user can access.
716. user_part_key_columns
Partition key column of the partition object owned by the current user.
717. user_part_indexes
Information about all object-level partitions in all partitions owned by the current user.
718. user_part_lobs
Table-level information of the large partition objects owned by the current user.
719. user_part_tables
The object-level partition information of the Partition Table owned by the current user.
720. user_partial_drop_tabs
In current user mode, some tables are deleted.
721. user_password_limits
Password parameter file assigned to the user.
722. user_policies
Security policies for all objects owned by the current user.
723. user_procedures
All functions and faults owned by the current user and their related attributes.
724. user_proxies
The connection information of the currently permitted proxy.
725. user_published_columns
Describes all privileged source columns.
726. user_queue_schedules
Information about the queue schedule.
727. user_queue_tables
Only describes the queues in the queue list created in user mode.
728. user_queues
All refresh groups of 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 column and the ref attribute 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
Resource limit of the current user.
735. user_resumable
Lists the recoverable statements executed by the current user.
736. user_rols_privs
Lists the roles granted to a user.
737. user_rsrc_consumer_group_privs
Lists All resource consumption groups granted to a user.
738. user_rsrc_manager_system_privs
List all users who have been granted SYSTEM privileges for the dbms_resource_manager package.
739. user_segments
Lists the storage allocation information of database segments belonging to user objects.
740. user_sequences
Description of user sequence.
741. user_snapshot_logs
All snapshot logs owned by the user.
742. user_snapshot_refresh_times
The number of times the snapshot is refreshed.
743. user_snapshots
Snapshots that can be viewed by users.
744. user_source
The text source of all stored objects of the user.
745. user_sorce_tables
Allows you to view all existing source tables with predefined privileges.
746. user_sqlj_type_attrs
All attributes of the sqlj object owned by the current user.
747. user_sqlj_type_methods
Type method of the current user.
748. user_sqlj_types
Sqlj object type information owned by the current user.
749. user_stored_settings
Permanent parameter settings for PL/SQL units stored by the current user.
750. user_subpart_col_statistics
Displays the column statistics and column charts of subpartitions of subpartition objects owned by the current user.
751. user_subpart_histograms
Displays the actual column chart data of the column chart in the subpartition of the table owned by the current user.
752. user_subpart_key_columns
Displays the column statistics and column charts of subpartitions of subpartition objects owned by the current user.
753. user_subscribed_columns
Allows the publisher to view all the columns of all specified releases.
754. user_subscribed_tables
Allows the publisher to view all the tables of all specified releases.
755. user_subscriptions
Allows publishers to view all reservations.
756. user_sysnonyms
Private synonym owned by the current user.
7 57. user_sys_privs
System privileges granted to users.
758. user_tab_col_statistics
Contains column statistics and column chart information in the user_tab_columns view.
759. user_tab_columns
Information of user tables, views, or clustering columns.
760. user_tab_comments
Users have comments on tables or views.
761. user_tab_histograms
The column chart of the User table.
762. user_tab_modifications
All Tables owned by the user that have been modified since the previous statistics.
763. user_tab_partitions
The name of each table sub-partition owned by the user, the storage attribute, and the name of the table and partition to which the sub-partition belongs.
764. user_tab_privs
Object.
765. user_tab_privs_made
Users have all privileges on objects.
766. user_tab_privs_recd
Contains privileges on objects. The user is the authorized user.
767. user_tab_subpartitions
Name of each sub-partition owned by the user, storage attribute, table and partition name.
768. user_tables
Description of the user-owned relational table.
769. user_tablespaces
Description of the accessible tablespace.
770. user_transformations
Conversion information owned by specific users.
771. user_trigger_cols
Column usage in a user trigger.
772. user_triggers
Description of user triggers.
773. user_types
User Type in the table.
774. user_type_attrs
User Type attributes.
775. user_ts_quotas
The user's tablespace quota.
776. user_methods
The method type of the user.
777. user_unused_col_tabs
Contains all tables with unused columns.
778. user_updatable_columns
Description of columns that can be modified in the connection view.
779. user_users
The information of the current user.
780. user_ustats
User-Defined statistics.
781. user_varrays
All arrays owned by the user.
782. user_views
User-owned view text.
9i data dictionary all view
783. all_all_tables
All Tables accessible to users.
784. all_arguments
All parameters of the object that the user can access.
785. all_associations
User-Defined statistics.
786. all_base_table_mviews
All materialized view information that users can access.
787. all_catalog
All tables that users can access, synonyms, soil and sequence.
788. all_cluster_hash_expressions
Aggregate hash functions that can be accessed by users.
789. all_clusters
All aggregates accessible to users.
790. all_col_comments
Comments on accessible tables or views.
791. all_col_privs
Lists the permissions on a column. The user or public is the grantor.
792. all_col_privs_made
Lists the permissions on a column. The user is the owner or authorizer.
793. all_col_privs_recd
Lists the permissions on the column. The user or public is the authorizer.
794. all_coll_types
The type of the set that can be accessed by the user.
795. all_cons_columns
Contains information about the columns that can be accessed in the constraint definition.
796. all_constraints
Lists the constraint definitions of an accessable table.
797. all_context
Displays the upstream and downstream information of the activity.
798. all_db_links
User-accessible data link.
799. all_def_audit_opts
Contains the default Object audit option applied when an object is created.
800. all_dependencies
The dependency between objects that can be accessed by users.
801. all_dim_hierarchies
Displays the dimension levels.
802. all_dim_join_key
Describes the connection between two dimensions.
803. all_dim_level_key
Describes dimension columns.
804. all_dim_levels
Description dimension level.
805. all_dimensions
Contains information about a dimension object.
806. all_directories
Description of all directories accessible to users.
807. all_errors
The current error on all objects that the user can access.
808. all_external_tables
External tables that can be accessed by users.
809. all_histograms
It is equal to the alias all_tab_histograms.
810. all_ind_columns
User-accessible index columns.
811. all_ind_expressions
The functional index expression of a table that you can access.
812. all_ind_partitions
It is an index partition and describes partition information at the partition level.
813. all_ind_subpartitons
It is an index sub-partition and describes the partition information at the sub-partition level.
814. all_indexes
The index description of a table that you can access.
815. all_indextype_commnets
The index type that you can access.
816. all_indextype_operators
Displays all operators supported by the index type.
817. all_indextypes
All index types are displayed.
818. all_internal_triggers
An internal trigger that can be accessed by the user.
819. all_jobs
All jobs in the database.
820. all_join_ind_columns
Describes the connection conditions of the location image you have accessed to connect to the index.
821. all_libraries
All databases accessible to users.
822. all_lob_partitions
A user-accessible table contains lob.
823. all_lob_subpartitions
Displays the shard level of the lob data subpartition.
824. all_lobs
A user-accessible table contains lob.
825. all_log_group_columns
Columns that can be accessed by users in a log group.
826. all_log_groups
The definition of a log group on a table that you can access.
827. all_method_params
Method parameters of the user-accessible type.
828. all_method_results
Method Result of the type that the user can access.
829. all_mview_aggregates
Grouping functions that appear in the select list of the materialized view of the aggregate class.
830. all_mview_analysis
Description may support query rewriting and materialized views with additional information that can be used for application analysis, but does not include remote
Non-static.
831. all_mview_detail_relations
Describes the name details referenced by the view image in the from list or indirectly in the from list.
832. all_mview_joins
Describes the connection between two columns in the WHERE clause of the materialized view.