Oracle FAQ 1000 (11)

9i data dictionary user view.

645. user_all_tables

Description of the table available to the user.

646. user_arguments

Lists the parameters in a user-accessible object.

647. user_associations

User-Defined statistics on the objects owned by the current user.

648. user_audit_object

Statement Audit Trail records of objects.

649. user_audit_session

All audit trail records of user connection or disconnection.

650. user_audit_statement

Lists the audit trail entries of grant, revoke, audit, noaudit, and alter system statements issued by the user.

651. user_audit_trail

User-related audit trail entries.

652. user_base_table_mviews

All materialized views of current user logs that use materialized views.

653. user_catalog

User-owned tables, views, synonyms and sequences.

654. user_clu_columns

Ing between columns in the User table and clustering columns.

655. user_cluster_hash_expressions

All clustering and hash functions that can be accessed by users.

656. user_clusters

Description of user-owned aggregation.

657. user_col_comments

List comments on columns of a user table or view.

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 the 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 in the User table.

664. user_db_links

Database chain information.

665. user_dependencies

The dependency between objects of the user.

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 idle 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, and various scores determined by analyze

Area 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

The grouping function that the current user has 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 additional information that can be used for application analysis.

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

User-owned PL/SQL object size.

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 of 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

The settings of the summary 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

The 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 the 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

Queue schedule information.

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 the system privileges of 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 was refreshed.

743. user_snapshots

Snapshots that can be viewed by the user.

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.

757. 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 and storage attribute of each table sub-partition owned by the user, and the name of the table and partition to which the sub-partition belongs.

764. user_tab_privs

Object privileges.

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

Transformation 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

User method type.

777. user_unused_col_tabs

All tables that contain unused columns.

778. user_updatable_columns

Description of columns that can be modified in the connection view.

779. user_users

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.