Oracle8i Reference Release 8.1.5 A67790-01 |
|
This chapter contains descriptions of data dictionary tables and views. To see the data dictionary views available to you, query the view DICTIONARY.
See Chapter 3, "Dynamic Performance (V$) Views" for descriptions of the V$ views.
In Trusted Oracle Server, each of the dictionary tables and views contains a column that indicates the label of each row in the table or view. Trusted Oracle also provides some additional dictionary tables and views, and some Oracle dictionary tables and views contain columns that support compatibility with Trusted Oracle applications.
See your Trusted Oracle documentation for more information about Trusted Oracle dictionary tables and views.
The following is an alphabetical reference of the data dictionary views accessible to all users of an Oracle Server. Most views can be accessed by any user with the CREATE_SESSION privilege.
The data dictionary views that begin with DBA_ are restricted. These views can be accessed only by users with the SELECT_ANY_TABLE privilege. This privilege is assigned to the DBA role when the system is initially installed.
This view describes all of the tables (object tables and relational tables) accessible to the user.
This view lists all of the arguments in the object which are accessible to the user.
This view lists user-defined statistics information.
This view lists all tables, views, synonyms, and sequences accessible to the user.
Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the object |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the object |
TABLE_TYPE |
VARCHAR2(11) |
|
Type of the object |
This view list all clusters accessible to the user.
This view list hash functions for all accessible clusters.
This view lists comments on columns of accessible tables and views.
This view lists grants on columns for which the user or PUBLIC is the grantee.
This view lists grants on columns for which the user is owner or grantor.
This view lists grants on columns for which the user or PUBLIC is the grantee.
This view displays the named collection types accessible to the user.
This view contains information about accessible columns in constraint definitions.
Note: If you create a constraint on a user-defined REF column, the system creates the constraint on the exploded columns that make up the REF column and hence column names of the constraint will be the column names of the exploded columns. These names will however have as their prefix the REF column's name.
This view lists constraint definitions on accessible tables.
This view lists active context information.
This view lists database links accessible to the user.
This view contains default object-auditing options that will be applied when objects are created.
This view lists dependencies between objects accessible to the user. Dependencies on views created without any database links are also available.
.This view represents dimension objects.
This view represents the relationship between a dimension level and a functionally dependent column. The table that the level columns are in must match the table of the dependent column.
This view represents a 1:n hierarchical relationship between a pair of levels in a dimension.
This view represents a dimension hierarchy.
Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the dimension |
DIMENSION_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the dimension |
HIERARCHY_NAME |
VARCHAR2(30) |
|
Hierarchy name |
This view represents a join between two dimension tables. The join is always specified between a parent dimension level column and a child column.
This view represents a dimension level. All columns of a dimension level must come from the same relation.
This view represents a column of a dimension level. The position of a column within a level is specified by KEY_POSITION.
This view contains the description of all directories accessible to the user.
This view lists current errors on all objects accessible to the user.
This view lists columns of the indexes on accessible tables.
Note: If you create an index on a user-defined REF column, the system creates the index on the exploded columns that make up the REF column and hence column names of the index will be the column names of the exploded columns. These names will however have as their prefix the REF column's name.
This view lists functional index expressions on accessible tables.
This view describes, for each index partition, the partition level partitioning information, the storage parameters for the partition, and various partition statistics determined by ANALYZE that the current user can access.
This view describes, for each index subpartition that the current user owns, the partition level partitioning information, the storage parameters for the subpartition, and various partition statistics determined by ANALYZE.
This view contains descriptions of indexes on tables accessible to the user. To gather statistics for this view, use the SQL command ANALYZE. This view supports parallel partitioned index scans.
This view lists all the indextypes.
This view lists all the operators supported by indextypes.
This view lists all jobs in the database.
This is a Trusted Oracle Server view that lists system labels. For more information, see your Trusted Oracle documentation.
This new data view lists all the libraries that a user can access.
This view displays the LOBs contained in tables accessible to the user.
This view displays the LOBs contained in tables accessible to the user.
This view displays partition-level attributes of LOB data subpartitions.
This view is a description view of method parameters of types accessible to the user.
This view is a description view of method results of types accessible to the user.
This view represents the grouping functions (aggregated measures) that appear in the SELECT list of an aggregated materialized view.
This view represents the materialized views that potentially support query rewrite and that have additional information that is available for analysis by applications. This view excludes any materialized view that references a remote table or that includes a reference to a non-static value such as SYSDATE or USER. It also excludes any materialized view that was created as a snapshot prior to Oracle8.1 and that was never altered to enable query rewrite.
This view represents the named detail relations that are either in the FROM list of a materialized view, or that are indirectly referenced through views in the FROM list. Inline views in the materialized view definition are not represented in this table.
This view represents a join between two columns in the WHERE clause of a materialized view.
This view represents the named detail relations that are either in the FROM list of a materialized view, or that are indirectly referenced through views in the FROM list. Inline views in the materialized view definition are not represented in this table.
This view describes the nested tables in tables accessible to the user.
This view contains descriptions of the object tables accessible to the user.
This view lists objects accessible to the user.
This view lists ancillary information for operators.
This view lists argument information for operator bindings.
This view lists operator bindings.
This view lists operators.
This view lists the set of hints which make up the outlines.
This view lists information about outlines.
This view contains column statistics and histogram information for table partitions that the current user can access.
This view contains the histogram data (end-points per histogram) for histograms on table partitions that the current user can access.
This view lists the object level partitioning information for all partitioned indexes that the current user can access.
This view describes the partitioning key columns for partitioned objects that the current user access.
This view describes table-level information for partitioned LOBs, including default attributes for LOB data partitions.
This view lists the object level partitioning information for partitioned tables the current user access.
This view describes tables which have partially dropped tables.
Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the object |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the table |
This view is a list of all policies on all tables and views that the user has access to.
This view displays information of the queues the user has enqueue or dequeue privilege on. If the user has any of the Advanced Queuing system privileges, like MANAGE ANY QUEUE, ENQUEUE ANY QUEUE or DEQUEUE ANY QUEUE, then all queues in the database will be displayed.
This view lists all the refresh groups that the user can access.
This view lists all the objects in refresh groups, where the user can access the group.
This view lists the names of the dependent detail or container tables of all the summaries or snapshots in the current schema.
This view describes the REF columns and REF attributes in object type columns accessible to the user.
This view lists all registered snapshots.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view lists descriptions of sequences accessible to the user.
This view lists all snapshot logs.
This view lists snapshot refresh times.
This view lists all snapshots accessible to the user.
This view lists the text source of all stored objects accessible to the user.
This view lists column statistics and histogram information for table subpartitions.
This view lists the actual histogram data (end-points per histogram) for histograms on table subpartitions.
SUBThis view lists subpartitioning key columns for tables (and Local indexes on tables) partitioned using the Composite Range/Hash method.
This view lists direct path load entries accessible to the user.
This view represents a summary object.
This view lists all synonyms accessible to the user.
This view contains column statistics and histogram information which is in the USER_TAB_COLUMNS view. For more information, see "USER_TAB_COLUMNS".
This view lists the columns of all tables, views, and clusters accessible to the user. To gather statistics for this view, use the SQL command ANALYZE.
This view lists comments on tables and views accessible to the user.
This view lists histograms on tables and views accessible to the user.
This view describes, for each table partition, the partition level partitioning information, the storage parameters for the partition, and various partition statistics determined by ANALYZE that the current user can access.
This view lists the grants on objects for which the user or PUBLIC is the grantee.
This view lists the user's grants and grants on the user's objects.
This view lists grants on objects for which the user or PUBLIC is the grantee.
This view describes, for each table subpartition, its name, name of the table and partition to which it belongs, and its storage attributes. Note that statistics will not be collected on a per-subpartition basis.
This view contains descriptions of relational tables accessible to the user. To gather statistics for this view, use the SQL command ANALYZE.
This view lists trigger information for triggers owned by the user, triggers on tables owned by the user, or all triggers if the user has the CREATE ANY TRIGGER privilege.
This view displays the usage of columns in triggers owned by user, on tables owned by user, or on all triggers if the user has the CREATE ANY TRIGGER privilege.
This view displays the attributes of types accessible to the user.
This view is a description of methods of types accessible to the user.
This view displays the types accessible to the user.
This view contains a description of all tables containing unused columns.
Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
The owner of the object |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
The name of the table |
COUNT |
NUMBER |
|
The number of unused columns |
This view contains a description of all columns that are updatable in a join view.
This view contains information about all users of the database.
Column | Datatype | NULL | Description |
---|---|---|---|
USERNAME |
VARCHAR2(30) |
NOT NULL |
Name of the user |
USER_ID |
NUMBER |
NOT NULL |
ID number of the user |
CREATED |
DATE |
NOT NULL |
User creation date |
This view contains information about the current user.
This view lists the text of views accessible to the user.
This view lists the text of views accessible to the user.
This view contains descriptions for audit trail action type codes.
Column | Datatype | NULL | Description |
---|---|---|---|
ACTION |
NUMBER |
NOT NULL |
Numeric audit trail action type code |
NAME |
VARCHAR2(27) |
NOT NULL |
Name of the type of audit trail action |
This view is included for compatibility with Oracle version 5. Use of this view is not recommended.
This is a synonym for USER_CATALOG. For more information, see "USER_CATALOG".
Stores the output for the ANALYZE command with the CHAINED ROWS option.
This is a synonym for USER_CLUSTERS. For more information, see "USER_CLUSTERS".
This view is accessed to create the DBA_OBJECT_SIZE and USER_OBJECT_SIZE views. For more information, see "DBA_OBJECT_SIZE" and "USER_OBJECT_SIZE".
This view is accessed to create the DBA_OBJECT_SIZE and USER_OBJECT_SIZE views. For more information, see "DBA_OBJECT_SIZE" and "USER_OBJECT_SIZE".
This view is included for compatibility with Oracle version 5. Use of this view is not recommended.
This is a synonym for USER_TAB_COLUMNS. For more information, see "USER_TAB_COLUMNS".
This view lists grants on columns for which the user is the grantor, grantee, or owner, or PUBLIC is the grantee.
This view is included for compatibility with Oracle version 6. Use of this view is not recommended.
This view contains information about incoming and outgoing connections for pending transactions.
This view contains information about distributed transactions awaiting recovery.
This view displays descriptions of all tables (object tables and relational tables) in the database.
This view lists analyze objects.
Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
The owner |
OBJECT_NAME |
VARCHAR2(30) |
NOT NULL |
The object name |
OBJECT_TYPE |
VARCHAR2(7) |
|
The object type |
This view lists user-defined statistics information.
This view lists audit trail entries produced by AUDIT NOT EXISTS and AUDIT EXISTS.
This view contains audit trail records for all objects in the system.
This view lists all audit trail records concerning CONNECT and DISCONNECT.
This view lists audit trail records concerning GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements.
This view lists all audit trail entries.
This view lists all sessions that have someone waiting on a lock they hold that are not themselves waiting on a lock.
Column | Datatype | NULL | Description |
---|---|---|---|
HOLDING_SESSION |
NUMBER |
|
Session holding a lock |
This view lists all database tables, views, synonyms, and sequences.
Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the object |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the object |
TABLE_TYPE |
VARCHAR2(11) |
|
Type of the object |
This view lists mappings of table columns to cluster columns.
This view contains description of all clusters in the database.
This view list hash functions for all clusters.
This view list all clusters accessible to the user.Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Name of owner of cluster |
CLUSTER_NAME |
VARCHAR2(30) |
NOT NULL |
Name of cluster |
HASH_EXPRESSION |
LONG |
|
Text of hash function of cluster |
This view lists comments on columns of all tables and views.
This view lists all grants on columns in the database.
This view displays all named collection types in the database such as VARRAYs, nested tables, object tables, and so on.
This view contains constraint definitions on all tables.
This view contains information about accessible columns in constraint definitions.
Note: If you create a constraint on a user-defined REF column, the system creates the constraint on the exploded columns that make up the REF column and hence column names of the constraint will be the column names of the exploded columns. These names will however have as their prefix the REF column's name.
This view lists all context namespaces information.
This view contains information about database files.
This view lists all database links in the database.
This view lists all DDL locks held in the database and all outstanding requests for a DDL lock.
This view lists dependencies to and from objects. Dependencies on views created without any database links are also available.
This view represents dimension objects.
This view represents the relationship between a dimension level and a functionally dependent column. The table that the level columns are in must match the table of the dependent column.
This view represents a 1:n hierarchical relationship between a pair of levels in a dimension.
This view represents a join between two dimension tables. The join is always specified between a parent dimension level column and a child column.
This view represents a dimension hierarchy.
Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the dimension |
DIMENSION_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the dimension |
HIERARCHY_NAME |
VARCHAR2(30) |
|
Hierarchy name |
This view represents a dimension level. All columns of a dimension level must come from the same relation.
This view represents a column of a dimension level. The position of a column within a level is specified by KEY_POSITION.
This view provides information on all directory objects in the database.
This view lists all DML locks held in the database and all outstanding requests for a DML lock.
Column | Datatype | NULL | Description |
---|---|---|---|
SESSION_ID |
NUMBER |
|
Session holding or acquiring the lock |
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the lock |
NAME |
VARCHAR2(30) |
NOT NULL |
Name of the lock |
MODE_HELD |
VARCHAR2(13) |
|
Lock mode: see Table 2-1, "Lock Modes for the DBA_DML_LOCKS View" |
MODE_REQUESTED |
VARCHAR2(13) |
|
Lock request type: see Table 2-1, "Lock Modes for the DBA_DML_LOCKS View" |
LAST_CONVERT |
NUMBER |
|
The last convert |
BLOCKING_OTHERS |
VARCHAR2(40) |
|
Blocking others |
Table 2-1 describes DML lock mode values that are valid for the MODE_HELD column.
This view lists current errors on all stored objects in the database.
This view contains a description of export files.
This view lists objects that have been incrementally exported.
This view contains the version number of the last export session.
Column | Datatypes | NULL | Description |
---|---|---|---|
EXP_VERSION |
NUMBER(3) |
NOT NULL |
Version number of the last export session |
This view lists the extents comprising all segments in the database.
This view lists the free extents in all tablespaces.
This view contains statistics on coalesced space in tablespaces.
This view contains descriptions for all indexes in the database. To gather statistics for this view, use the SQL command ANALYZE. This view supports parallel partitioned index scans.
This view contains descriptions of the columns comprising the indexes on all tables and clusters.
Note: If you create an index on a user-defined REF column, the system creates the index on the exploded columns that make up the REF column and hence column names of the index will be the column names of the exploded columns. These names will however have as their prefix the REF column's name.
This view lists functional index expressions on all tables and clusters.
This view describes, for each index partition, the partition level partitioning information, the storage parameters for the partition, and various partition statistics determined by ANALYZE.
This view describes, for each index subpartition that the current user owns, the partition level partitioning information, the storage parameters for the subpartition, and various partition statistics determined by ANALYZE.
This view lists all the indextypes.
This view lists all the operators supported by indextypes.
This view lists all jobs in the database.
This view lists all jobs in the database that are currently running.
Column | Datatype | NULL | Description |
---|---|---|---|
SID |
NUMBER |
|
Identifier of process that is executing the job. See "V$LOCK". |
JOB |
NUMBER |
|
Identifier of job. This job is currently executing. |
FAILURES |
NUMBER |
|
Number of times this job started and failed since its last success |
LAST_DATE |
DATE |
|
Date that this job last successfully executed |
LAST_SEC |
VARCHAR2(8) |
|
Same as LAST_DATE. This is when the last successful execution started. |
THIS_DATE |
DATE |
|
Date that this job started executing |
THIS_SEC |
VARCHAR2(8) |
|
Same as THIS_DATE. This is when the job started executing. |
INSTANCE |
NUMBER |
|
Indicates which instance can execute or is executing the job; the default is 0 |
This view lists all the libraries in the database.
This view displays the LOBs contained in all tables.
This view displays the LOBs contained in tables accessible to the user.
This view displays partition-level attributes of LOB data subpartitions.
This view lists all locks or latches held in the database, and all outstanding requests for a lock or latch.
This view has a row for each lock or latch that is being held, and one row for each outstanding request for a lock or latch.
This view is a description of method parameters of types in the database.
This view is a description of method results of all types in the database.
This view represents the grouping functions (aggregated measures) that appear in the SELECT list of an aggregated materialized view.
This view represents the materialized views that potentially support query rewriting and that have additional information that is available for analysis by applications. This view excludes any materialized view that references a remote table or that includes a reference to a non-static value such as SYSDATE or USER. It does show all materialized views upon which Oracle would allow ENABLE QUERY REWRITE, not just those that are actually enabled for query rewrite.
This view represents the named detail relations that are either in the FROM list of a materialized view, or that are indirectly referenced through views in the FROM list. Inline views in the materialized view definition are not represented in this table.
This view represents a join between two columns in the WHERE clause of a materialized view.
This view represents the named detail relations that are either in the FROM list of a materialized view, or that are indirectly referenced through views in the FROM list. Inline views in the materialized view definition are not represented in this table.
This view displays descriptions of the nested tables contained in all tables.
This view lists the sizes, in bytes, of various PL/SQL objects.
This view displays descriptions of all object tables in the database.
This view lists all objects in the database.
This view lists auditing options for all objects owned by a user.
This view lists ancillary information for operator bindings.
This view lists argument information for operator bindings.
This view lists operator bindings.
This view lists operators.
This view lists the set of hints which make up the outlines.
This view lists information about outlines.
This view contains column statistics and histogram information for all table partitions.
This view contains the histogram data (end-points per histogram) for histograms on all table partitions.
This view lists the object level partitioning information for all partitioned indexes.
This view describes the partitioning key columns for all partitioned objects.
This view describes table-level information for partitioned LOBs, including default attributes for LOB data partitions.
This view lists the object level partitioning information for all the partitioned tables.
This view describes tables which have partially dropped tables.
Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the object |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the table |
This view gives information about unresolved transactions (either due to failure or if the co-ordinator has not sent a commit/rollback).
This view lists policies.
This view describes current system privileges being audited across the system and by user.
This view displays all profiles and their limits.
This view describes the current schedules for propagating messages.
This view describes the names and types of the queues in all of the queue tables created in the database. For more information about this view and Advanced Queuing, see the Oracle8i Application Developer's Guide - Fundamentals.
This view describes the operational characteristics for every queue in a database. For more information about this view and Advanced Queuing, see the Oracle8i Application Developer's Guide - Fundamentals.
This view lists all the children in any refresh group.
This view lists all the refresh groups.
This view lists all of the objects in refresh groups.
This view describes the REF columns and REF attributes in object type columns of all the tables in the database.
This view lists all the snapshot repgroups at this site.
This view is used to get information about remote snapshots of local tables.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view lists all refresh groups.
This view lists all roles that exist in the database.
Column | Datatype | NULL | Description |
---|---|---|---|
ROLE |
VARCHAR2(30) |
NOT NULL |
Role name |
PASSWORD_REQUIRED |
VARCHAR2(8) |
|
Indicates if the role requires a password to be enabled |
This view lists roles granted to users and roles.
This view contains descriptions of rollback segments.
This view lists all resource consumer groups and the users and roles to which they have been granted.
This view lists all resource consumer groups which exist in the database.
This view lists all the users and roles which have been granted system privileges pertaining to the resource manager.
This view lists all resource plans which exist in the database.
This view lists all resource plan directives which exist in the database.
This view lists information about rulesets.
This view contains information about storage allocated for all database segments.
This view contains descriptions of all sequences in the database.
This view lists all snapshot logs in the database.
This view lists all filter columns (excluding PK cols) being logged in the snapshot logs.
This view lists snapshot refresh times.
This view lists all snapshots in the database.
This view contains source of all stored objects in the database.
This view contains information which describes current system auditing options across the system and by user.
This view lists column statistics and histogram information for table subpartitions.
This view lists the actual histogram data (end-points per histogram) for histograms on table subpartitions.
This view lists subpartitioning key columns for tables (and Local indexes on tables) partitioned using the Composite Range/Hash method.
This view lists all synonyms in the database.
This view lists system privileges granted to users and roles.
This view contains column statistics and histogram information which is in the DBA_TAB_COLUMNS view. For more information, see "DBA_TAB_COLUMNS".
This view contains information which describes columns of all tables, views, and clusters. To gather statistics for this view, use the SQL command ANALYZE.
This view contains comments on all tables and views in the database.
This view lists histograms on columns of all tables.
This view describes, for each table partition, the partition level partitioning information, the storage parameters for the partition, and various partition statistics determined by ANALYZE.
This view lists all grants on objects in the database.
This view describes, for each table subpartition, its name, name of the table and partition to which it belongs, and its storage attributes. Note that statistics will not be collected on a per-subpartition basis.
This view contains descriptions of all relational tables in the database. To gather statistics for this view, use the SQL command ANALYZE.
This view contains descriptions of all tablespaces.
This view contains information about database temp files.
This view lists all triggers in the database.
This view lists column usage in all triggers.
This view lists tablespace quotas for all users.
This view displays the attributes of types in the database.
This view is a description of methods of all types in the database.
This view displays all abstract datatypes in the database.
This view contains a description of all tables containing unused columns.
Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
The owner of the object |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
The name of the table |
COUNT |
NUMBER |
|
The number of unused columns |
This view contains a description of columns that are updatable by the database administrator in a join view. See Oracle8i Concepts for information on updatable join views.
This view lists information about all users of the database.
This view contains information about the current user.
This view lists the text of views accessible to the user.
This view contains the text of all views in the database.
This view shows all the sessions that have someone waiting on a lock they hold, but that are not themselves waiting on a lock.
This view lists registered alerts.
This view lists user-allocated locks.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view, created by UTLDTREE.SQL, contains information on the object dependency tree. For user SYS, this view displays shared cursors (and only shared cursors) that depend on the object. For all other users, it displays objects other than shared cursors. Other users can access SYS.DEPTREE for information on shared cursors.
Column | Datatype | NULL | Description |
---|---|---|---|
NESTED_LEVEL |
NUMBER |
|
Nesting level in the dependency tree |
TYPE |
VARCHAR2(15) |
|
Object type |
OWNER |
VARCHAR2(30) |
|
Object owner |
NAME |
VARCHAR2(1002) |
|
Object name |
SEQ# |
NUMBER |
|
Sequence number in the dependency tree. Used for ordering queries. (See also: "IDEPTREE".) |
This is a synonym for DICTIONARY. For more information, see "DICTIONARY".
This view contains descriptions of data dictionary tables and views.
Column | Datatype | NULL | Description |
---|---|---|---|
TABLE_NAME |
VARCHAR2(30) |
|
Name of the object |
COMMENTS |
VARCHAR2(4000) |
|
Text comment on the object |
This view contains descriptions of columns in data dictionary tables and views.
Column | Datatype | NULL | Description |
---|---|---|---|
TABLE_NAME |
VARCHAR2(30) |
|
Name of the object that contains the column |
COLUMN_NAME |
VARCHAR2(30) |
|
Name of the column |
COMMENTS |
VARCHAR2(4000) |
|
Text comment on the column |
This view is accessed to create the DBA_OBJECT_SIZE and USER_OBJECT_SIZE views. For more information, see "DBA_OBJECT_SIZE" and "USER_OBJECT_SIZE".
This view contains information on violations of integrity constraints. This view is created by the UTLEXCPT.SQL script.
This is a Parallel Server view. This view displays the mapping of PCM locks to datafiles as specified in initialization parameter GC_FILES_TO_LOCKS. For more information on this parameter, see "GC_FILES_TO_LOCKS".
For more information on this view, see Oracle8i Parallel Server Concepts and Administration.
This is a Parallel Server view. This view displays the number of blocks pinged per datafile. You can use this information to determine access usage of existing datafiles for better settings of GC_FILES_TO_LOCKS. For more information on this parameter, see "GC_FILES_TO_LOCKS".
For more information, see Oracle8i Parallel Server Concepts and Administration.
This view is the equivalent of DBA_DATA_FILES. Oracle recommends you use DBA_DATA_FILES instead of FILEXT$. For more information, see "DBA_DATA_FILES".
Column | Datatype | NULL | Description |
---|---|---|---|
FILE# |
NUMBER |
NOT NULL |
Absolute file number |
MAXEXTEND |
NUMBER |
|
Maximum file size |
INC |
NUMBER |
|
Increment amount |
This view contains one row that displays the global name of the current database.
Column | Datatype | NULL | Description |
---|---|---|---|
GLOBAL_NAME |
VARCHAR2(4000) |
|
Global name of the database |
This view contains information about all of the capabilities (that is, features) associated with non-Oracle (FDS) data stores.
This view contains data dictionary information about non-Oracle (FDS) data stores.
This view contains initialization parameter information about non-Oracle (FDS) data stores.
This view contains information about base capability (that is, base features) of the non-Oracle (FDS) data store.
Column | Datatype | NULL | Description |
---|---|---|---|
CAP_NUMBER |
NUMBER |
NOT NULL |
Capability number |
CAP_DESCRIPTION |
VARCHAR2(255) |
|
Description of the capability |
This view displays information from the base data dictionary translation table.
This view contains information about the class-specific (driver) capabilities belonging to the non-Oracle (FDS) data store.
This view displays information from the non-Oracle data store (FDS) class-specific data dictionary translations.
This view displays information about the non-Oracle (FDS) class-specific initialization parameters.
This view contains information about the privileges on objects that are granted to users.
This view contains information about all of the distributed external objects accessible from the Oracle Server.
This view contains information about all of the granted privileges that are not tied to any particular object.
This view contains information about legal non-Oracle (FDS) classes.
This view contains information about non-Oracle (FDS) instances.
This view contains information about instance-specific capabilities (that is, features).
This view displays information from the non-Oracle (FDS) instance-specific data dictionary translations.
This view contains information about the non-Oracle (FDS) instance-specific initialization parameters.
This view, created by UTLDTREE.SQL, lists the indented dependency tree. It is a pre-sorted, pretty-print version of DEPTREE.
Column | Datatype | NULL | Description |
---|---|---|---|
NESTED_LEVEL |
NUMBER |
|
Nesting level in the dependency tree |
TYPE |
VARCHAR2(15) |
|
Object type |
OWNER |
VARCHAR2(30) |
|
Object owner |
NAME |
VARCHAR2(1002) |
|
Object name |
This is a synonym for USER_INDEXES. For more information, see "USER_INDEXES".
This view contains information from the ANALYZE INDEX ... VALIDATE STRUCTURE command.
This view stores information from the last ANALYZE INDEX ... VALIDATE STRUCTURE command.
This view lists permanent NLS parameters of the database.
Column | Datatype | NULL | Description |
---|---|---|---|
PARAMETER |
VARCHAR2(30) |
NOT NULL |
Parameter name |
VALUE |
VARCHAR2(30) |
|
Parameter value |
This view lists NLS parameters of the instance.
Column | Datatype | NULL | Description |
---|---|---|---|
PARAMETER |
VARCHAR2(30) |
|
Parameter name |
VALUE |
VARCHAR2(30) |
|
Parameter value |
This view lists NLS parameters of the user session.
Column | Datatype | NULL | Description |
---|---|---|---|
PARAMETER |
VARCHAR2(30) |
|
Parameter name |
VALUE |
VARCHAR2(30) |
|
Parameter value |
This is a synonym for USER_OBJECTS. For more information, see "USER_OBJECTS".
If there are index entries that point to corrupt rows when you run the DUMP_ORPHAN_KEYS procedure, the orphan key table is populated as a log of the activity and provides index information.
This view is accessed to create the DBA_OBJECT_SIZE and USER_OBJECT_SIZE views. For more information, see "DBA_OBJECT_SIZE" and "USER_OBJECT_SIZE".
This view is accessed to create the DBA_OBJECT_SIZE and USER_OBJECT_SIZE views. For more information, see "DBA_OBJECT_SIZE" and "USER_OBJECT_SIZE".
This view is the default table for results of the EXPLAIN PLAN statement. It is created by UTLXPLAN.SQL, and it contains one row for each step in the execution plan.
This view contains pluggable set checks.
This view contains version and status information for component products.
Column | Datatype | NULL | Description |
---|---|---|---|
PRODUCT |
VARCHAR2(64) |
|
Product name |
VERSION |
VARCHAR2(64) |
|
Version number |
STATUS |
VARCHAR2(64) |
|
Status of release |
This view describes users who can assume the identity of other users.
This table contains information on stubs generated by the PSTUB utility so that an Oracle Forms 3.0 client can call stored procedures in an Oracle database.
Note: The contents of this table are intended only for use by the PSTUB utility.
This view contains information on public synonyms.
This view lists dependencies to and from objects, by object number.
Column | Datatype | NULL | Description |
---|---|---|---|
OBJECT_ID |
NUMBER |
NOT NULL |
Object number |
REFERENCED_OBJECT_ID |
NUMBER |
NOT NULL |
Referenced object (the parent object) |
This view shows all Advanced Queuing object privileges granted to the session.
RC_ views are not created by default in the database, they are only available after you create an optional recovery catalog (which contains schemas containing information about backups) for use with Recovery Manager. Please see the Oracle8i Backup and Recovery Guide for details about these views.
The REPAIR_TABLE view lists any corruptions found by the CHECK_OBJECT procedure. It also displays information about how the corruptions would be addressed if the
FIX_CORRUPT_BLOCKS procedure is executed. This information is also used by the FIX_CORRUPT_BLOCKS and REFORMAT_CORRUPT_BLOCKS procedures on execution.
This view lists the cost for each resource.
Column | Datatype | NULL | Description |
---|---|---|---|
RESOURCE_NAME |
VARCHAR2(32) |
NOT NULL |
Name of the resource |
UNIT_COST |
NUMBER |
NOT NULL |
Cost of the resource |
This view contains descriptions for resources. It maps the resource name to the resource number.
Column | Datatype | NULL | Description |
---|---|---|---|
RESOURCE# |
NUMBER |
NOT NULL |
Numeric resource code |
TYPE# |
NUMBER |
NOT NULL |
Name of type |
NAME |
VARCHAR2(32) |
NOT NULL |
Name of resource |
This view contains information about roles granted to other roles. (Information is only provided about roles to which the user has access.)
This view contains information about system privileges granted to roles. Information is provided only about roles to which the user has access.
This view contains information about table privileges granted to roles. Information is provided only about roles to which the user has access.
This is a synonym for USER_SEQUENCES. For more information see "USER_SEQUENCES".
This view lists set attributes information for the current session.
This view lists the privileges that are currently available to the user.
Column | Datatype | NULL | Description |
---|---|---|---|
PRIVILEGE |
VARCHAR2(40) |
NOT NULL |
Name of the privilege |
This view lists the roles that are currently enabled to the user.
Column | Datatype | NULL | Description |
---|---|---|---|
ROLE |
VARCHAR2(30) |
NOT NULL |
Name of the role |
This view is accessed to create the DBA_OBJECT_SIZE and USER_OBJECT_SIZE views. For more information, see "DBA_OBJECT_SIZE", and "USER_OBJECT_SIZE".
This view contains information about auditing option type codes.
Column | Datatype | NULL | Description |
---|---|---|---|
OPTION# |
NUMBER |
NOT NULL |
Numeric auditing option type code |
NAME |
VARCHAR2(40) |
NOT NULL |
Name of the auditing option |
PROPERTY |
NUMBER |
NOT NULL |
|
This is a synonym for USER_SYNONYMS. For more information, see "USER_SYNONYMS".
This view is included for compatibility with Oracle version 5. Use of this view is not recommended.
This view is included for compatibility with Oracle version 5. Use of this view is not recommended.
This view is included for compatibility with Oracle version 5. Use of this view is not recommended.
This view is included for compatibility with Oracle version 5. Use of this view is not recommended.
This view contains information about system privilege codes.
Column | Datatype | NULL | Description |
---|---|---|---|
PRIVILEGE |
NUMBER |
NOT NULL |
Numeric privilege type code |
NAME |
VARCHAR2(40) |
NOT NULL |
Name of the type of privilege |
PROPERTY |
NUMBER |
NOT NULL |
|
This view maps object IDs to object types and segment data block addresses.
This view is included for compatibility with Oracle version 5. Use of this view is not recommended.
This view contains information on grants on objects for which the user is the grantor, grantee, or owner, or PUBLIC is the grantee. This view is included for compatibility with Oracle version 6. Use of this view is not recommended.
This view contains information about access privilege codes.
Column | Datatype | NULL | Description |
---|---|---|---|
PRIVILEGE |
NUMBER |
NOT NULL |
Numeric privilege (auditing option) type code |
NAME |
VARCHAR2(40) |
NOT NULL |
Name of the type of privilege (auditing option) |
This is a synonym for USER_TABLES. For more information, see "USER_TABLES".
This view is included for compatibility with Oracle version 5. Use of this view is not recommended.
This view displays whether a server is trusted or untrusted.
For example:
If all servers are trusted, then TRUSTED_SERVERS returns:
TRUST NAME ------- ------ Trusted ALL
If none of the servers are trusted, then TRUSTED_SERVERS returns:
TRUST NAME ------- ------ Untrusted ALL
If all servers are trusted, except DB1
, then TRUSTED_SERVERS returns:
TRUST NAME ------- ------ Untrusted DB1
If all servers are untrusted, except DB1
, then TRUSTED_SERVERS returns:
TRUST NAME ------- ------ Trusted DB1
For more information on this view see Oracle8i Distributed Database Systems.
This view, created by CATPITR.SQL provides information on any dependencies or restrictions which might prevent tablespace point-in-time recovery from proceeding. This view applies only to the tablespace point-in-time recovery feature. For more information, see Oracle8i Backup and Recovery Guide.
This view lists all objects lost as a result of performing tablespace point-in-time recovery. This view applies only to the tablespace point-in-time recovery feature.
This view contains pluggable check information.
This table contains descriptions of the tables (object tables and relational tables) available to the user.
This view lists the arguments in the object which are accessible to the user.
This view lists user-defined statistics information
This view, created by CATAUDIT.SQL, lists audit trail records for statements concerning objects.
This view, created by CATAUDIT.SQL, lists all audit trail records concerning connections and disconnections for the user.
This view, created by CATAUDIT.SQL, lists audit trail entries for the following statements issued by the user: GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM.
This view, created by CATAUDIT.SQL, lists audit trail entries relevant to the user.
This view lists tables, views, synonyms, and sequences owned by the user.
Column | Datatype | NULL | Description |
---|---|---|---|
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the object |
TABLE_TYPE |
VARCHAR2(11) |
|
Type of the object |
This view contains descriptions of user's own clusters.
This view list hash functions for the users' hash clusters.
This view list all clusters accessible to the user.Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Name of owner of cluster |
CLUSTER_NAME |
VARCHAR2(30) |
NOT NULL |
Name of cluster |
HASH_EXPRESSION |
LONG |
|
Text of hash function of cluster |
This view contains a mapping of columns in user's tables to cluster columns.
This view lists comments on columns of user's tables and views.
Column | Datatype | NULL | Description |
---|---|---|---|
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Object name |
COLUMN_NAME |
VARCHAR2(30) |
NOT NULL |
Column name |
COMMENTS |
VARCHAR2(4000) |
|
Comment on the column |
This view lists grants on columns for which the user is the owner, grantor, or grantee.
This view lists all grants on columns of objects owned by the user.
This view lists grants on columns for which the user is the grantee.
This new data dictionary view displays the user's named collection types.
This view lists constraint definitions on user's tables.
This view contains information about columns in constraint definitions owned by the user.
Note: If you create a constraint on a user-defined REF column, the system creates the constraint on the exploded columns that make up the REF column and hence column names of the constraint will be the column names of the exploded columns. These names will however have as their prefix the REF column's name.
This view contains information on database links owned by the user.
This view lists dependencies to and from a user's objects. Dependencies on views created without any database links are also available.
This view represents dimension objects.
This view represents the relationship between a dimension level and a functionally dependent column. The table that the level columns are in must match the table of the dependent column.
This view represents a 1:n hierarchical relationship between a pair of levels in a dimension.
This view represents a join between two dimension tables. The join is always specified between a parent dimension level column and a child column.
This view represents a dimension hierarchy.
Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the dimension |
DIMENSION_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the dimension |
HIERARCHY_NAME |
VARCHAR2(30) |
|
Hierarchy name |
This view represents a dimension level. All columns of a dimension level must come from the same relation.
This view represents a column of a dimension level. The position of a column within a level is specified by KEY_POSITION.
This view lists current errors on all a user's stored objects.
This view lists extents of the segments belonging to a user's objects.
This view lists the free extents in tablespaces accessible to the user.
This view contains descriptions of the user's own indexes. To gather statistics for this view, use the SQL command ANALYZE. This view supports parallel partitioned index scans.
This view lists columns of the user's indexes or on user's tables.
Note: If you create an index on a user-defined REF column, the system creates the index on the exploded columns that make up the REF column and hence column names of the index will be the column names of the exploded columns. These names will however have as their prefix the REF column's name.
This view lists functional index expressions on user's tables.
This view describes, for each index partition that the current user owns, the partition level partitioning information, the storage parameters for the partition, and various partition statistics determined by ANALYZE.
This view describes, for each index subpartition that the current user owns, the partition level partitioning information, the storage parameters for the subpartition, and various partition statistics determined by ANALYZE.
This view lists all the indextypes.
This view lists all the operators supported by indextypes.
This view lists all jobs owned by the user. For more information, see the Oracle8i Administrator's Guide.
This view lists all the libraries that a user owns.
This view displays the user's LOBs contained in the user's tables. It is only for internal LOBs, so BLOBs, CLOBs, and NCLOBs are OK. External LOBs (i.e.,BFILES) are not.
This view displays the LOBs contained in tables accessible to the user.
This view displays partition-level attributes of LOB data subpartitions.
This view is a description of method parameters of the user's types.
This view is a description of method results of the user's types.
This view represents the grouping functions (aggregated measures) that appear in the SELECT list of an aggregated materialized view.
This view represents the materialized views that potentially support query rewrite and that have additional information that is available for analysis by applications. This view excludes any materialized view that references a remote table or that includes a reference to a non-static value such as SYSDATE or USER. It also excludes any materialized view that was created as a snapshot prior to Oracle8.1 and that was never altered to enable query rewrite.
This view represents the named detail relations that are either in the FROM list of a materialized view, or that are indirectly referenced through views in the FROM list. Inline views in the materialized view definition are not represented in this table.
This view represents a join between two columns in the WHERE clause of a materialized view.
This view represents the named detail relations that are either in the FROM list of a materialized view, or that are indirectly referenced through views in the FROM list. Inline views in the materialized view definition are not represented in this table.
This view describes the nested tables contained in the user's own tables.
This view contains descriptions of the object tables available to the user.
This view lists objects owned by the user.
This view lists the sizes, in bytes, of various PL/SQL objects.
This view, created by CATAUDIT.SQL, lists auditing options for all objects owned by a user.
This view lists ancillary information for operators.
This view lists argument information for operator bindings.
This view lists operator bindings.
This view lists operators.
This view lists the set of hints which make up the outlines.
This view lists information about outlines.
This view contains column statistics and histogram information for table partitions that the current user owns.
This view contains the histogram data (end-points per histogram) for histograms on table partitions that the current user can access.
This view describes the partitioning key columns for partitioned objects that the current user owns.
This view lists the object level partitioning information for all partitioned indexes that the user owns.
This view describes table-level information for partitioned LOBs, including default attributes for LOB data partitions.
This view describes the object level partitioning information for partitioned tables that the current user owns.
This view describes tables which have partially dropped tables.
Column | Datatype | NULL | Description |
---|---|---|---|
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the table |
This view describes the password profile parameters that are assigned to the user.
Column | Datatype | NULL | Description |
---|---|---|---|
RESOURCE_NAME |
VARCHAR2(32) |
NOT NULL |
Name of the password resource |
LIMIT |
VARCHAR2(40) |
|
Value of the resource limit |
This view lists policies on objects that are under the user's schema.
This view lists information about queue schedules.
This view describes only the queues in the queue tables created in the user's schema. For more information about this view and Advanced Queuing, see the Oracle8i Application Developer's Guide - Fundamentals.
This view describes the operational characteristics for every queue in the user's schema. For more information about this view and Advanced Queuing, see the Oracle8i Application Developer's Guide - Fundamentals.
This view lists all the refresh groups.
This view lists all the objects in refresh groups, where the user owns the refresh group.
This view describes the REF columns and REF attributes in the object type columns of the user's tables.
This view lists users' registered snapshots.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view is used with Advanced Replication. For more information, see Oracle8i Replication.
This view displays the resource limits for the current user.
Column | Datatype | NULL | Description |
---|---|---|---|
RESOURCE_NAME |
VARCHAR2(32) |
NOT NULL |
Name of the resource |
LIMIT |
VARCHAR2(40) |
|
Limit placed on this resource |
This view lists roles granted to the user.
This view lists all resource consumer groups granted to the user.
This view lists all the users who are granted system privileges for the DBMS_RESOURCE_MANAGER package.
Column | Datatype | NULL | Description |
---|---|---|---|
PRIVILEGE |
VARCHAR2(40) |
NOT NULL |
What type of privilege the user has |
ADMIN_OPTION |
VARCHAR2(3) |
|
Whether the grant was with the ADMIN option |
This view lists information about rulesets.
This view lists information about storage allocation for database segments belonging to a user's objects.
This view lists descriptions of the user's sequences.
This view lists snapshots that the user can view.
This view lists all snapshot logs owned by the user.
This view lists snapshot refresh times.
This view contains text source of all stored objects belonging to the user.
This view lists column statistics and histogram information for table subpartitions.
This view lists the actual histogram data (end-points per histogram) for histograms on table subpartitions.
This view lists subpartitioning key columns for tables (and Local indexes on tables) partitioned using the Composite Range/Hash method.
This view lists the user's private synonyms.
This view lists system privileges granted to the user.
This view contains column statistics and histogram information which is in the USER_TAB_COLUMNS view. For more information, see "USER_TAB_COLUMNS".
This view contains information about columns of user's tables, views, and clusters. To gather statistics for this view, use the SQL command ANALYZE.
This view contains comments on the tables and views owned by the user.
This view lists histograms on columns of user's tables.
This view describes, for each table partition, the partition level partitioning information, the storage parameters for the partition, and various partition statistics determined by ANALYZE that the current user owns.
This view contains information on grants on objects for which the user is the owner, grantor, or grantee.
This view contains information about all grants on objects owned by the user.
This view contains information about grants on objects for which the user is the grantee.
This view describes, for each table subpartition, its name, name of the table and partition to which it belongs, and its storage attributes. Note that statistics will not be collected on a per-subpartition basis.
This view contains a description of the user's own relational tables. To gather statistics for this view, use the SQL command ANALYZE.
This view contains descriptions of accessible tablespaces.
This view contains descriptions of the user's triggers.
This view displays the usage of columns in triggers owned by the user or on one of the user's tables.
This view contains information about tablespace quotas for the user.
This view displays the user's types in a table.
This view displays the attributes of the user's types.
This view is a description of the user's methods types.
This view contains a description of all tables containing unused columns.
Column | Datatype | NULL | Description |
---|---|---|---|
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
The name of the table |
COUNT |
NUMBER |
|
The number of unused columns |
This view contains a description of columns that are updatable to the user in a join view.
This view contains information about the current user.
This view contains information about the current user.
This view lists the text of views accessible to the user.
This view contains the text of views owned by the user.