Oracle faq one thousand [701 to 800]

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.