Oracle basics-9

833. all_mview_keys
Describes the name details of a materialized view from or indirectly referenced by a view image in the from list.
834. all_mview_refresh_times
Refresh time of the user-accessible materialized view.
835. all_mviews
All materialized views that users can access.
836. all_nested_tables
User-accessible nested tables.
837. all_object_tables
Description of the object table that you can access.
838. all_opancillary
Displays the auxiliary information of operators.
839. all_oparguments
Displays the variable information bound to the operator.
840. all_opbindings
Bind the display operator.
841. all_operator_comments
All comments of user-defined operations that can be accessed by users.
842. all_operators
Accessible operators.
843. all_outline_hints
Prompts about the summary that can be accessed by the user.
844. all_outlines
All profiles accessible to users.
845. all_part_col_statistics
Column statistics and column chart information of table partitions that you can access.
846. all_part_histograms
You can access the columnar data of table partitions.
847. all_part_indexes
The object-level partition information of all the partition indexes that the current user can access.
848. all_part_key_columns
The partition key value of the partition object that the current user can access.
849. all_part_lobs
Table-level information of the lob partition that the current user can access.
850. all_part_tables
The object-level partition information of the partition table that the current user can access.
851. all_partial_drop_tabs
A table with a local Delete table that the current user can access.
852. all_policies
All the policies on all tables and views that the current user can access.
853. all_procedures
Lists All functions, processes, and related attributes.
854. all_published_columns
Describes the source table columns with special privileges.
855. all_queue_tables
All queues in the list of teams that the current user can access.
856. all_queues
Displays the queue information that the user has queue or queue privileges.
857. all_refresh
All refresh groups that the current user can access.
858. all_refresh_children
Lists all objects in the refresh group.
859. all_refresh_dependencies
Displays the dependency details or container table names of all profiles or snapshots in the current mode.
860. all_refs
The ref column and the ref attribute in the object type column that the current user can access.
861. all_registered_mviews
All materialized views that the current user can access.
862. all_registered_snapshots
List all registered snapshots.
863. all_sequences
All sequences accessible to the current user.
864. all_snapshot_logs
Materialized View logs that can be accessed by the current user.
865. all_snapshot_refresh_times
The number of times the snapshot was refreshed.
866. all_source
Source of all storage objects that the current user can access.
867. all_source_tables
Allows the publisher to view all existing source tables.
868. all_sqlj_type_attrs
All attributes of the sqlj object that can be accessed by the current user.
869. all_sqlj_type_methods
The type and method that the current user can access.
870. all_sqlj_types
Information about sqlj object types that can be accessed by the current user.
871. all_stored_settings
The current user has permanent parameter settings for storing PL/SQL units with its execution privileges.
872. all_subpart_col_statistics
Contains column statistics and column information of user_tab_columns.
873. all_subpart_histograms
Displays the actual column chart information of the column chart in the table subpartition.
874. all_subpart_key_columns
Displays the subpartition key values of a table partitioned using the composite range/HASH method.
875. all_subscribed_columns
Allows publishers to view all the release columns they have subscribed.
876. all_subscribed_tables
Allows publishers to view all the released tables they have subscribed.
877. all_subscriptions
Allow publishers to view all their reservations.
878. all_sumdelia
User-accessible direct path load entries.
879. all_synonyms
All synonyms that a user can access.
880. all_tab_col_statistics
Contains column statistics and column information of all_tab_columns.
881. all_tab_columns
All tables, views, and clustered columns that you can access.
882. all_tab_comments
Annotations in accessible tables and views.
883. all_tab_histograms
You can access the column information in tables and views.
884. all_tab_modifications
The table that is modified after the last statistics that can be accessed by the user.
885. all_tab_privs
Lists permissions on objects. users or public users are granted permissions.
886. all_tab_privs_made
Lists user authorization and authorization on user objects.
887. all_tab_privs_recd
Lists permissions on objects. users and public are granted.
888. all_tab_subpartitions
The name, storage attribute, and table and partition name of each sub-partition that you can access.
889. all_tables
Description of a user-accessible relational table.
890. all_triggers
User-owned triggers.
891. all_trigger_cols
User-owned trigger columns and usage.
892. all_type_attrs
User-accessible type attributes.
893. all_type_methods
The method of the type that the user can access.
894. all_types
The type that the user can access.
895. all_unused_col_tabs
Contains all tables with unused columns.
896. all_updatable_columns
Description of all columns that can be modified in the mo join view.
897. all_users
Information of all users in the database.
898. all_ustats
User-accessible user-defined statistics.
899. all_varrays
All arrays accessible to users.
900. all_views
The text of a view that you can access.
Oracle9i Data Dictionary
901. chained_rows
Stores the output of the analyze command with the list chained rows clause.
902. chainge_sources
Allows the publisher to view existing changed resources.
903. change_sets
Allows the publisher to view existing change settings.
904. change_tables
Allows publishers to view existing change tables.
905. code_pieces
Oracle accesses this view to create a view on the object size.
906. code_size
Oracle accesses this view to create a view on the object size.
907. Cols
User_tab_columns synonym.
908. column_privileges
Lists the authorization status of a column.
909. database_properties
Lists the names of the currently default temporary tablespace.
910. dbms_alert_info
Describes the registered warning.
911. dbms_lock_allocated
Description of the locks assigned by the user.
912. deptree
Utldtree. SQL is used to create an object dependency tree.
913. dict_columns
Description of the data dictionary table and View column.
914. Dictionary
Description of the data dictionary table and View column.
915. error_size
Oracle accesses this view to create a view on the object size.
916. Exceptions
Contains the violation information of the complete constraint.
917. file_locks
The real-time application cluster view displays the PCM lock image of the specified data file in gc_files_to_locks.
918. file_ping
In the real-time application cluster view, the number of connected data files is displayed.
919. global_name
The global name of the current database.
920. hs_all_caps
Contains all compatibility information about non-Oracle (FDS) data storage.
921. hs_all_dd
Contains data dictionary information about non-Oracle (FDS) data storage.
922. hs_all_inits
Contains information about initialization parameters for non-Oracle (FDS) data storage.
923. hs_base_caps
Contains basic performance information about non-Oracle (FDS) data storage.
924. hs_base_dd
Displays information about the basic data dictionary translation table.
925. hs_class_caps
Contains the specified performance information of a class that is not stored in Oracle (FDS.
926. hs_class_init
Contains information about the initialization parameters specified by the non-Oracle (FDS) class.
927. hs_external_object_privileges
Contains the privileges on the objects granted to the user.
928. hs_external_objects
Contains information about all distributed external objects that can be accessed by the Oracle server.
929. hs_fds_class
Contains legal information about non-Oracle (FDS) classes.
930. hs_fds_inst
Contains information about legal non-Oracle (FDS) instances.
931. hs_inst_caps
Contains the performance information specified by the instance.
932. hs_inst_dd
Displays information about data dictionary translation for non-Oracle (FDS) instances.
933. hs_inst_init
Displays information about initialization parameters specified by non-Oracle (FDS) instances.
934. ideptree
List dependency trees.
935. index_histogram
Contains information about the analyze index... validate structure command.
936. index_stats
Contains information about the analyze index... validate structure command.
937. nls_database_prameters
Lists permanent NLS parameter information in the database.
938. nls_instance_parameters
Lists permanent NLS parameter information in an instance.
939. nls_session_parameters
Lists permanent NLS parameter information in a session.
940. parsed_pieces
Oracle accesses this view to create a view on the object size.
941. parsed_size
Oracle accesses this view to create a view on the object size.
942. plan_table
The result table of the explain Plan statement.
943. pluggable_set_check
Including pluggable settings.
944. product_component_version
Contains the version and status information of the product.
945. proxy_users
Describe the users that can assume other user identities.
946. pstubtbl
Contains the information on the Root generated by the pstub program, so that Oracle form3.0 customers can call the Oracle number
Stored Procedures in the database.
947. public_deptendency
Lists object dependencies.
948. pubucsyn
Contains information on Common synonyms.
949. queue_privileges
Displays the advanced query objects granted to the session by those privileges.
950. resource_cost
List the overhead of each resource.
951. resource_map
Contains the description of the resource.
952. role_role_privs
Contains the role information granted to other roles.
953. role_sys_privs
Contains information about the system privileges granted to the role.
954. role_tab_privs
Contains the table privileges granted to the role.
955. session_context
Lists the attributes and value settings of the current session.
956. session_privs
Lists the privileges currently available to users.
957. session_roles
Lists the roles currently enabled for users.
958. source_size
Oracle accesses this view to create a view on the object size.
959. stmt_audit_option_map
Information that contains the audit option type code.
960. syscatalog
This view is used to maintain compatibility with oracle5. we recommend that you do not use this view.
961. sysfiles
This view is used to maintain compatibility with oracle5. we recommend that you do not use this view.
962. syssegobj
This view is used to maintain compatibility with oracle5. we recommend that you do not use this view.
963. system_privilege_map
Contains information about the system privilege code.
964. sys_objects
Map the Object ID to the object type and segment data block address.
965. table_privilege_map
Contains information about accessing privileged code.
966. table_privileges
Contains privileged information on objects.
967. tabquotas
This view is used to maintain compatibility with oracle5. we recommend that you do not use this view.
968. trusted_servers
Whether the server is trusted or not.
969. ts_pitr_check
Provides dependency or constraint information that may prevent tablespace from resuming in time.
970. ts_pitr_objects_to_be_dropped
Lists all objects lost as the result of timely recovery of the tablespace.
971. uni_pluggable_set_check
Protects pluggable inspection information.