2
Static Data Dictionary Views

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.

Data Dictionary 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.

ALL_ALL_TABLES

This view describes all of the tables (object tables and relational tables) accessible to the user.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

Owner of the table

TABLE_NAME

VARCHAR2(30)

Name of the table

TABLESPACE_NAME

VARCHAR2(30)

Name of the tablespace containing the table

CLUSTER_NAME

VARCHAR2(30)

Name of the cluster, if any, to which the table belongs

IOT_NAME

VARCHAR2(30)

Name of the index organized table, if any, to which the overflow entry belongs

PCT_FREE

NUMBER

Minimum percentage of free space in a bloc

PCT_USED

NUMBER

Minimum percentage of used space in a block

INI_TRANS

NUMBER

Initial number of transactions

MAX_TRANS

NUMBER

Maximum number of transactions

INITIAL_EXTENT

NUMBER

Size of the initial extent in bytes

NEXT_EXTENT

NUMBER

Size of secondary extents in bytes

MIN_EXTENTS

NUMBER

Minimum number of extents allowed in the segment

MAX_EXTENTS

NUMBER

Maximum number of extents allowed in the segment

PCT_INCREASE

NUMBER

Percentage increase in extent size

FREELISTS

NUMBER

Number of process freelists allocated in this segment

FREELIST_GROUPS

NUMBER

Number of freelist groups allocated in this segment

LOGGING

VARCHAR2(3)

Logging attribute

BACKED_UP

VARCHAR2(1)

Has table been backed up since last modification?

NUM_ROWS

NUMBER

The number of rows in the table

BLOCKS

NUMBER

The number of used blocks in the table

EMPTY_BLOCKS

NUMBER

The number of empty (never used) blocks in the table

AVG_SPACE

NUMBER

The average available free space in the table

CHAIN_CNT

NUMBER

The number of chained rows in the table

AVG_ROW_LEN

NUMBER

The average row length, including row overhead

AVG_SPACE_FREELIST
_BLOCKS

NUMBER

The average freespace of all blocks on a freelist

NUM_FREELIST_BLOCKS

NUMBER

The number of blocks on the freelist

DEGREE

VARCHAR2(10)

The number of threads per instance for scanning the table

INSTANCES

VARCHAR2(10)

The number of instances across which the table is to be scanned

CACHE

VARCHAR2(5)

Whether the table is to be cached in the buffer cache

TABLE_LOCK

VARCHAR2(8)

Whether table locking is enabled or disabled

SAMPLE_SIZE

NUMBER

The sample size used in analyzing this table

LAST_ANALYZED

DATE

The date of the most recent time this table was analyzed

PARTITIONED

VARCHAR2(3)

Is this table partitioned? YES or NO

IOT_TYPE

VARCHAR2(12)

If an index organized table, then IOT_TYPE is IOT or IOT_OVERFLOW else NULL

TABLE_TYPE_OWNER

VARCHAR2(0)

Owner of the type of the table if the table is a typed table

TABLE_TYPE

VARCHAR2(0)

Type of the table if the table is a typed table

PACKED

VARCHAR2(0)

If the table is a typed table, does it store objects in packed format?

OBJECT_ID_TYPE

VARCHAR2(16)

If user-defined OID, then USER-DEFINED, else if system generated OID, then SYSTEM GENERATED

TABLE_TYPE_OWNER

VARCHAR2(30)

Owner of the type of the table if the table is a typed table

TABLE_TYPE

VARCHAR2(30)

Type of the table if the table is a typed table

TEMPORARY

VARCHAR2(1)

Can the current session only see data that it place in this object itself?

NESTED

VARCHAR2(3)

Is the table a nested table?

BUFFER_POOL

VARCHAR2(7)

Name of the default buffer pool for the appropriate object

ROW_MOVEMENT

VARCHAR2(8)

Whether partitioned row movement is enabled or disabled

GLOBAL_STATS

VARCHAR2(3)

Are the statistics calculated without merging underlying partitions?

USER_STATS

VARCHAR2(3)

Were the statistics entered directly by the user?

DURATION

VARCHAR2(15)

If temporary table, then duration is sys$session or sys$transaction, else NULL

SKIP_CORRUPT

VARCHAR2(8)

Whether skip corrupt blocks is enabled or disabled

Column	Datatype	Description
OWNER	VARCHAR2(30)	Owner of the table
TABLE_NAME	VARCHAR2(30)	Name of the table
TABLESPACE_NAME	VARCHAR2(30)	Name of the tablespace containing the table
CLUSTER_NAME	VARCHAR2(30)	Name of the cluster, if any, to which the table belongs
IOT_NAME	VARCHAR2(30)	Name of the index organized table, if any, to which the overflow entry belongs
PCT_FREE	NUMBER	Minimum percentage of free space in a bloc
PCT_USED	NUMBER	Minimum percentage of used space in a block
INI_TRANS	NUMBER	Initial number of transactions
MAX_TRANS	NUMBER	Maximum number of transactions
INITIAL_EXTENT	NUMBER	Size of the initial extent in bytes
NEXT_EXTENT	NUMBER	Size of secondary extents in bytes
MIN_EXTENTS	NUMBER	Minimum number of extents allowed in the segment
MAX_EXTENTS	NUMBER	Maximum number of extents allowed in the segment
PCT_INCREASE	NUMBER	Percentage increase in extent size
FREELISTS	NUMBER	Number of process freelists allocated in this segment
FREELIST_GROUPS	NUMBER	Number of freelist groups allocated in this segment
LOGGING	VARCHAR2(3)	Logging attribute
BACKED_UP	VARCHAR2(1)	Has table been backed up since last modification?
NUM_ROWS	NUMBER	The number of rows in the table
BLOCKS	NUMBER	The number of used blocks in the table
EMPTY_BLOCKS	NUMBER	The number of empty (never used) blocks in the table
AVG_SPACE	NUMBER	The average available free space in the table
CHAIN_CNT	NUMBER	The number of chained rows in the table
AVG_ROW_LEN	NUMBER	The average row length, including row overhead
AVG_SPACE_FREELIST _BLOCKS	NUMBER	The average freespace of all blocks on a freelist
NUM_FREELIST_BLOCKS	NUMBER	The number of blocks on the freelist
DEGREE	VARCHAR2(10)	The number of threads per instance for scanning the table
INSTANCES	VARCHAR2(10)	The number of instances across which the table is to be scanned
CACHE	VARCHAR2(5)	Whether the table is to be cached in the buffer cache
TABLE_LOCK	VARCHAR2(8)	Whether table locking is enabled or disabled
SAMPLE_SIZE	NUMBER	The sample size used in analyzing this table
LAST_ANALYZED	DATE	The date of the most recent time this table was analyzed
PARTITIONED	VARCHAR2(3)	Is this table partitioned? YES or NO
IOT_TYPE	VARCHAR2(12)	If an index organized table, then IOT_TYPE is IOT or IOT_OVERFLOW else NULL
TABLE_TYPE_OWNER	VARCHAR2(0)	Owner of the type of the table if the table is a typed table
TABLE_TYPE	VARCHAR2(0)	Type of the table if the table is a typed table
PACKED	VARCHAR2(0)	If the table is a typed table, does it store objects in packed format?
OBJECT_ID_TYPE	VARCHAR2(16)	If user-defined OID, then USER-DEFINED, else if system generated OID, then SYSTEM GENERATED
TABLE_TYPE_OWNER	VARCHAR2(30)	Owner of the type of the table if the table is a typed table
TABLE_TYPE	VARCHAR2(30)	Type of the table if the table is a typed table
TEMPORARY	VARCHAR2(1)	Can the current session only see data that it place in this object itself?
NESTED	VARCHAR2(3)	Is the table a nested table?
BUFFER_POOL	VARCHAR2(7)	Name of the default buffer pool for the appropriate object
ROW_MOVEMENT	VARCHAR2(8)	Whether partitioned row movement is enabled or disabled
GLOBAL_STATS	VARCHAR2(3)	Are the statistics calculated without merging underlying partitions?
USER_STATS	VARCHAR2(3)	Were the statistics entered directly by the user?
DURATION	VARCHAR2(15)	If temporary table, then duration is sys$session or sys$transaction, else NULL
SKIP_CORRUPT	VARCHAR2(8)	Whether skip corrupt blocks is enabled or disabled

ALL_ARGUMENTS

This view lists all of the arguments in the object which are accessible to the user.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Username of the owner of the object

OBJECT_NAME

VARCHAR2(30)

Procedure or function name

OVERLOAD

VARCHAR2(40)

Overload unique identifier

PACKAGE_NAME

VARCHAR2(30)

Package name

OBJECT_ID

NUMBER

NOT NULL

Object number of the object

ARGUMENT_NAME

VARCHAR2(30)

Argument name

POSITION

NUMBER

NOT NULL

Position in argument list, or NULL for function return value

SEQUENCE

NUMBER

NOT NULL

Argument sequence, including all nesting levels

DATA_LEVEL

NUMBER

NOT NULL

Nesting depth of argument for composite types

DATA_TYPE

VARCHAR2(14)

Datatype of the argument

DEFAULT_VALUE

LONG

Default value for the argument

DEFAULT_LENGTH

NUMBER

Length of default value for the argument

IN_OUT

VARCHAR2(9)

Argument direction (IN, OUT, or IN/OUT)

DATA_LENGTH

NUMBER

Length of the column in bytes

DATA_PRECISION

NUMBER

Length: decimal digits (NUMBER) or binary digits (FLOAT)

DATA_SCALE

NUMBER

Digits to right of decimal point in a number

RADIX

NUMBER

Argument radix for a number

CHARACTER_SET_NAME

VARCHAR2(44)

Character set name for the argument

TYPE_OWNER

VARCHAR2(30)

Owner name of the type

TYPE_NAME

VARCHAR2(30)

Name

TYPE_SUBNAME

VARCHAR2(30)

This is valid only in case of package local types; in such cases, the package name is the name and the type name is the subname

TYPE_LINK

VARCHAR2(128)

Database link valid only in case of package local types, in case the package is remote

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Username of the owner of the object
OBJECT_NAME	VARCHAR2(30)		Procedure or function name
OVERLOAD	VARCHAR2(40)		Overload unique identifier
PACKAGE_NAME	VARCHAR2(30)		Package name
OBJECT_ID	NUMBER	NOT NULL	Object number of the object
ARGUMENT_NAME	VARCHAR2(30)		Argument name
POSITION	NUMBER	NOT NULL	Position in argument list, or NULL for function return value
SEQUENCE	NUMBER	NOT NULL	Argument sequence, including all nesting levels
DATA_LEVEL	NUMBER	NOT NULL	Nesting depth of argument for composite types
DATA_TYPE	VARCHAR2(14)		Datatype of the argument
DEFAULT_VALUE	LONG		Default value for the argument
DEFAULT_LENGTH	NUMBER		Length of default value for the argument
IN_OUT	VARCHAR2(9)		Argument direction (IN, OUT, or IN/OUT)
DATA_LENGTH	NUMBER		Length of the column in bytes
DATA_PRECISION	NUMBER		Length: decimal digits (NUMBER) or binary digits (FLOAT)
DATA_SCALE	NUMBER		Digits to right of decimal point in a number
RADIX	NUMBER		Argument radix for a number
CHARACTER_SET_NAME	VARCHAR2(44)		Character set name for the argument
TYPE_OWNER	VARCHAR2(30)		Owner name of the type
TYPE_NAME	VARCHAR2(30)		Name
TYPE_SUBNAME	VARCHAR2(30)		This is valid only in case of package local types; in such cases, the package name is the name and the type name is the subname
TYPE_LINK	VARCHAR2(128)		Database link valid only in case of package local types, in case the package is remote

ALL_ASSOCIATIONS

This view lists user-defined statistics information.

Column Datatype NULL Description

OBJECT_OWNER

VARCHAR2(30)

NOT NULL

Owner of the object for which the association is being defined

OBJECT_NAME

VARCHAR2(30)

NOT NULL

Object name for which the association is being defined

COLUMN_NAME

VARCHAR2(30)

Column name in the object for which the association is being defined

OBJECT_TYPE

VARCHAR2(9)

Schema type of the object - column, type, package or function

STATSTYPE_SCHEMA

VARCHAR2(30)

Owner of the statistics type

STATSTYPE_NAME

VARCHAR2(30)

Name of Statistics type which contains the cost, selectivity or stats funcs

DEF_SELECTIVITY

NUMBER

Default Selectivity if any of the object

DEF_CPU_COST

NUMBER

Default CPU cost if any of the object

DEF_IO_COST

NUMBER

Default I/O cost if any of the object

DEF_NET_COST

NUMBER

Default Networking cost if any of the object

Column	Datatype	NULL	Description
OBJECT_OWNER	VARCHAR2(30)	NOT NULL	Owner of the object for which the association is being defined
OBJECT_NAME	VARCHAR2(30)	NOT NULL	Object name for which the association is being defined
COLUMN_NAME	VARCHAR2(30)		Column name in the object for which the association is being defined
OBJECT_TYPE	VARCHAR2(9)		Schema type of the object - column, type, package or function
STATSTYPE_SCHEMA	VARCHAR2(30)		Owner of the statistics type
STATSTYPE_NAME	VARCHAR2(30)		Name of Statistics type which contains the cost, selectivity or stats funcs
DEF_SELECTIVITY	NUMBER		Default Selectivity if any of the object
DEF_CPU_COST	NUMBER		Default CPU cost if any of the object
DEF_IO_COST	NUMBER		Default I/O cost if any of the object
DEF_NET_COST	NUMBER		Default Networking cost if any of the object

ALL_CATALOG

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

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

ALL_CLUSTERS

This view list all clusters accessible to the user.

Column Datatype NULL Description

CLUSTER_NAME

VARCHAR2(30)

NOT NULL

Name of the cluster

OWNER

VARCHAR2(30)

NOT NULL

The owner of the cluster

CLUSTER_NAME

VARCHAR2(30)

NOT NULL

The name of the cluster

TABLESPACE_NAME

VARCHAR2(30)

NOT NULL

Name of the tablespace containing the cluster

PCT_FREE

NUMBER

Minimum percentage of free space in a block

PCT_USED

NUMBER

NOT NULL

Minimum percentage of used space in a block

KEY_SIZE

NUMBER

Estimated size of cluster key plus associated rows

INI_TRANS

NUMBER

NOT NULL

Initial number of transactions

MAX_TRANS

NUMBER

NOT NULL

Maximum number of transactions

INITIAL_EXTENT

NUMBER

Size of the initial extent in bytes

NEXT_EXTENT

NUMBER

Size of secondary extents in bytes

MIN_EXTENTS

NUMBER

NOT NULL

Minimum number of extents allowed in the segment

MAX_EXTENTS

NUMBER

NOT NULL

Maximum number of extents allowed in the segment

PCT_INCREASE

NUMBER

NOT NULL

Percentage increase in extent size

FREELISTS

NUMBER

Number of process freelists allocated to this segment

FREELIST_GROUPS

NUMBER

Number of freelist groups allocated to this segment

AVG_BLOCKS_PER
_KEY

NUMBER

Number of blocks in the table divided by number of hash keys

CLUSTER_TYPE

VARCHAR2(5)

Type of cluster: B-Tree index or hash

FUNCTION

VARCHAR2(15)

If a hash cluster, the hash function

HASHKEYS

NUMBER

If a hash cluster, the number of hash keys (hash buckets)

DEGREE

VARCHAR2(10)

The number of threads per instance for scanning the cluster

INSTANCES

VARCHAR2(10)

The number of instances across which the cluster is to be scanned

CACHE

VARCHAR2(5)

Whether the cluster is to be cached in the buffer cache

BUFFER_POOL

VARCHAR2(7)

Name of the default buffer pool for the appropriate object

SINGLE_TABLE

VARCHAR2(5)

Y if the cluster is single table; N if not

Column	Datatype	NULL	Description
CLUSTER_NAME	VARCHAR2(30)	NOT NULL	Name of the cluster
OWNER	VARCHAR2(30)	NOT NULL	The owner of the cluster
CLUSTER_NAME	VARCHAR2(30)	NOT NULL	The name of the cluster
TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Name of the tablespace containing the cluster
PCT_FREE	NUMBER		Minimum percentage of free space in a block
PCT_USED	NUMBER	NOT NULL	Minimum percentage of used space in a block
KEY_SIZE	NUMBER		Estimated size of cluster key plus associated rows
INI_TRANS	NUMBER	NOT NULL	Initial number of transactions
MAX_TRANS	NUMBER	NOT NULL	Maximum number of transactions
INITIAL_EXTENT	NUMBER		Size of the initial extent in bytes
NEXT_EXTENT	NUMBER		Size of secondary extents in bytes
MIN_EXTENTS	NUMBER	NOT NULL	Minimum number of extents allowed in the segment
MAX_EXTENTS	NUMBER	NOT NULL	Maximum number of extents allowed in the segment
PCT_INCREASE	NUMBER	NOT NULL	Percentage increase in extent size
FREELISTS	NUMBER		Number of process freelists allocated to this segment
FREELIST_GROUPS	NUMBER		Number of freelist groups allocated to this segment
AVG_BLOCKS_PER _KEY	NUMBER		Number of blocks in the table divided by number of hash keys
CLUSTER_TYPE	VARCHAR2(5)		Type of cluster: B-Tree index or hash
FUNCTION	VARCHAR2(15)		If a hash cluster, the hash function
HASHKEYS	NUMBER		If a hash cluster, the number of hash keys (hash buckets)
DEGREE	VARCHAR2(10)		The number of threads per instance for scanning the cluster
INSTANCES	VARCHAR2(10)		The number of instances across which the cluster is to be scanned
CACHE	VARCHAR2(5)		Whether the cluster is to be cached in the buffer cache
BUFFER_POOL	VARCHAR2(7)		Name of the default buffer pool for the appropriate object
SINGLE_TABLE	VARCHAR2(5)		Y if the cluster is single table; N if not

ALL_CLUSTER_HASH_EXPRESSIONS

This view list hash functions for all accessible clusters.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Name of the owner of the cluster

CLUSTER_NAME

VARCHAR2(30)

NOT NULL

The name of the cluster

HASH_EXPRESSION

LONG

Text of hash function of cluster

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Name of the owner of the cluster
CLUSTER_NAME	VARCHAR2(30)	NOT NULL	The name of the cluster
HASH_EXPRESSION	LONG		Text of hash function of cluster

ALL_COL_COMMENTS

This view lists comments on columns of accessible tables and views.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the object

TABLE_NAME

VARCHAR2(30)

NOT NULL

Name of the object

COLUMN_NAME

VARCHAR2(30)

NOT NULL

Name of the column

COMMENTS

VARCHAR2(4000)

Comment on the column

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Name of the column
COMMENTS	VARCHAR2(4000)		Comment on the column

ALL_COL_PRIVS

This view lists grants on columns for which the user or PUBLIC is the grantee.

Column Datatype NULL Description

GRANTOR

VARCHAR2(30)

NOT NULL

Name of the user who performed the grant

GRANTEE

VARCHAR2(30)

NOT NULL

Name of the user to whom access was granted

TABLE_SCHEMA

VARCHAR2(30)

NOT NULL

Schema of the object

TABLE_NAME

VARCHAR2(30)

NOT NULL

Name of the object

COLUMN_NAME

VARCHAR2(30)

NOT NULL

Name of the column

PRIVILEGE

VARCHAR2(40)

NOT NULL

Privilege on the column

GRANTABLE

VARCHAR2(3)

YES if the privileges were granted with ADMIN OPTION; otherwise NO

Column	Datatype	NULL	Description
GRANTOR	VARCHAR2(30)	NOT NULL	Name of the user who performed the grant
GRANTEE	VARCHAR2(30)	NOT NULL	Name of the user to whom access was granted
TABLE_SCHEMA	VARCHAR2(30)	NOT NULL	Schema of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Name of the column
PRIVILEGE	VARCHAR2(40)	NOT NULL	Privilege on the column
GRANTABLE	VARCHAR2(3)		YES if the privileges were granted with ADMIN OPTION; otherwise NO

ALL_COL_PRIVS_MADE

This view lists grants on columns for which the user is owner or grantor.

Column Datatype NULL Description

GRANTEE

VARCHAR2(30)

NOT NULL

Name of the user to whom access was granted

OWNER

VARCHAR2(30)

NOT NULL

Username of the owner of the object

TABLE_NAME

VARCHAR2(30)

NOT NULL

Name of the object

COLUMN_NAME

VARCHAR2(30)

NOT NULL

Name of the column

GRANTOR

VARCHAR2(30)

NOT NULL

Name of the user who performed the grant

PRIVILEGE

VARCHAR2(40)

NOT NULL

Privilege on the column

GRANTABLE

VARCHAR2(3)

YES if the privilege was granted with ADMIN OPTION; otherwise NO

Column	Datatype	NULL	Description
GRANTEE	VARCHAR2(30)	NOT NULL	Name of the user to whom access was granted
OWNER	VARCHAR2(30)	NOT NULL	Username of the owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Name of the column
GRANTOR	VARCHAR2(30)	NOT NULL	Name of the user who performed the grant
PRIVILEGE	VARCHAR2(40)	NOT NULL	Privilege on the column
GRANTABLE	VARCHAR2(3)		YES if the privilege was granted with ADMIN OPTION; otherwise NO

ALL_COL_PRIVS_RECD

This view lists grants on columns for which the user or PUBLIC is the grantee.

Column Datatype NULL Description

GRANTEE

VARCHAR2(30)

NOT NULL

Name of the user to whom access was granted

OWNER

VARCHAR2(30)

NOT NUL

Username of the owner of the object

TABLE_NAME

VARCHAR2(30)

NOT NULL

Name of the object

COLUMN_NAME

VARCHAR2(30)

NOT NULL

Name of the object

GRANTOR

VARCHAR2(30)

NOT NULL

Name of the user who performed the grant

PRIVILEGE

VARCHAR2(40)

NOT NULL

Privilege on the column

GRANTABLE

VARCHAR2(3)

YES if the privilege was granted with ADMIN OPTION; otherwise NO

Column	Datatype	NULL	Description
GRANTEE	VARCHAR2(30)	NOT NULL	Name of the user to whom access was granted
OWNER	VARCHAR2(30)	NOT NUL	Username of the owner of the object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Name of the object
GRANTOR	VARCHAR2(30)	NOT NULL	Name of the user who performed the grant
PRIVILEGE	VARCHAR2(40)	NOT NULL	Privilege on the column
GRANTABLE	VARCHAR2(3)		YES if the privilege was granted with ADMIN OPTION; otherwise NO

ALL_COLL_TYPES

This view displays the named collection types accessible to the user.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the type

TYPE_NAME

VARCHAR2(30)

NOT NULL

Name of the type

COLL_TYPE

VARCHAR2(30)

NOT NULL

Collection type

UPPER_BOUND

NUMBER

Maximum size of the VARRAY type

ELEM_TYPE_MOD

VARCHAR2(7)

Type modifier of the element

ELEM_TYPE_OWNER

VARCHAR2(30)

Owner of the type of the element

ELEM_TYPE_NAME

VARCHAR2(30)

Name of the type of the element

LENGTH

NUMBER

Length of the CHAR element or maximum length of the VARCHAR or VARCHAR2 element

PRECISION

NUMBER

Decimal precision of the NUMBER or DECIMAL element or binary precision of the FLOAT element

SCALE

NUMBER

Scale of the NUMBER or DECIMAL element

CHARACTER_SET
_NAME

VARCHAR2(44)

The name of the character set: CHAR_CS NCHAR_CS

ELEM_STORAGE

VARCHAR2(7)

Storage optimization specification for VARRAY of numeric elements

NULLS_STORED

VARCHAR2(3)

Is null information stored with each VARRAY element?

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the type
TYPE_NAME	VARCHAR2(30)	NOT NULL	Name of the type
COLL_TYPE	VARCHAR2(30)	NOT NULL	Collection type
UPPER_BOUND	NUMBER		Maximum size of the VARRAY type
ELEM_TYPE_MOD	VARCHAR2(7)		Type modifier of the element
ELEM_TYPE_OWNER	VARCHAR2(30)		Owner of the type of the element
ELEM_TYPE_NAME	VARCHAR2(30)		Name of the type of the element
LENGTH	NUMBER		Length of the CHAR element or maximum length of the VARCHAR or VARCHAR2 element
PRECISION	NUMBER		Decimal precision of the NUMBER or DECIMAL element or binary precision of the FLOAT element
SCALE	NUMBER		Scale of the NUMBER or DECIMAL element
CHARACTER_SET _NAME	VARCHAR2(44)		The name of the character set: CHAR_CS NCHAR_CS
ELEM_STORAGE	VARCHAR2(7)		Storage optimization specification for VARRAY of numeric elements
NULLS_STORED	VARCHAR2(3)		Is null information stored with each VARRAY element?

ALL_CONS_COLUMNS

This view contains information about accessible columns in constraint definitions.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the constraint definition

CONSTRAINT_NAME

VARCHAR2(30)

NOT NULL

Name associated with the constraint definition

TABLE_NAME

VARCHAR2(30)

NOT NULL

Name associated with table with constraint definition

COLUMN_NAME

VARCHAR2(4000)

Name associated with column or attribute of the object type column specified in the constraint definition

POSITION

NUMBER

Original position of column or attribute in definition

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the constraint definition
CONSTRAINT_NAME	VARCHAR2(30)	NOT NULL	Name associated with the constraint definition
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name associated with table with constraint definition
COLUMN_NAME	VARCHAR2(4000)		Name associated with column or attribute of the object type column specified in the constraint definition
POSITION	NUMBER		Original position of column or attribute in definition

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.

ALL_CONSTRAINTS

This view lists constraint definitions on accessible tables.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the constraint definition

CONSTRAINT_NAME

VARCHAR2(30)

NOT NULL

Name associated with the constraint definition

CONSTRAINT_TYPE

VARCHAR2(1)

Type of constraint definition: C (check constraint on a table), P (primary key), U (unique key), R (referential integrity), or V (with check option, on a view), or O (with read only, on a view)

TABLE_NAME

VARCHAR2(30)

NOT NULL

Name associated with table with constraint definition

SEARCH_CONDITION

LONG

Text of search condition for table check

R_OWNER

VARCHAR2(30)

Owner of table used in referential constraint

R_CONSTRAINT
_NAME

VARCHAR2(30)

Name of unique constraint definition for referenced table

DELETE_RULE

VARCHAR2(9)

Delete rule for a referential constraint: CASCADE / NO ACTION

STATUS

VARCHAR2(8)

Enforcement status of constraint: ENABLED or DISABLED

DEFERRABLE

VARCHAR2(14)

Indicates whether the constraint is deferrable

DEFERRED

VARCHAR2(9)

Indicates whether the constraint was initially deferred

VALIDATED

VARCHAR2(13)

Indicates whether all data obeys the constraint: VALIDATED, NOT VALIDATED

GENERATED

VARCHAR2(14)

Indicates whether the name system is generated

BAD

VARCHAR2(3)

Creating this constraint should give ORA-02436. Rewrite it before 2000 AD.

RELY

VARCHAR2(4)

If set, this flag will be used in the optimizer

LAST_CHANGE

DATE

Indicates when the constraint was last enabled or disabled

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the constraint definition
CONSTRAINT_NAME	VARCHAR2(30)	NOT NULL	Name associated with the constraint definition
CONSTRAINT_TYPE	VARCHAR2(1)		Type of constraint definition: C (check constraint on a table), P (primary key), U (unique key), R (referential integrity), or V (with check option, on a view), or O (with read only, on a view)
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name associated with table with constraint definition
SEARCH_CONDITION	LONG		Text of search condition for table check
R_OWNER	VARCHAR2(30)		Owner of table used in referential constraint
R_CONSTRAINT _NAME	VARCHAR2(30)		Name of unique constraint definition for referenced table
DELETE_RULE	VARCHAR2(9)		Delete rule for a referential constraint: CASCADE / NO ACTION
STATUS	VARCHAR2(8)		Enforcement status of constraint: ENABLED or DISABLED
DEFERRABLE	VARCHAR2(14)		Indicates whether the constraint is deferrable
DEFERRED	VARCHAR2(9)		Indicates whether the constraint was initially deferred
VALIDATED	VARCHAR2(13)		Indicates whether all data obeys the constraint: VALIDATED, NOT VALIDATED
GENERATED	VARCHAR2(14)		Indicates whether the name system is generated
BAD	VARCHAR2(3)		Creating this constraint should give ORA-02436. Rewrite it before 2000 AD.
RELY	VARCHAR2(4)		If set, this flag will be used in the optimizer
LAST_CHANGE	DATE		Indicates when the constraint was last enabled or disabled

ALL_CONTEXT

This view lists active context information.

Column Datatype NULL Description

NAMESPACE

VARCHAR2(30)

NOT NULL

The name of the context namespace

SCHEMA

VARCHAR2(30)

NOT NULL

The schema name of the designated package which can set attributes using this namespace

PACKAGE

VARCHAR2(30)

NOT NULL

The package name of the designated package which can set attributes using this namespace

Column	Datatype	NULL	Description
NAMESPACE	VARCHAR2(30)	NOT NULL	The name of the context namespace
SCHEMA	VARCHAR2(30)	NOT NULL	The schema name of the designated package which can set attributes using this namespace
PACKAGE	VARCHAR2(30)	NOT NULL	The package name of the designated package which can set attributes using this namespace

ALL_DB_LINKS

This view lists database links accessible to the user.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Username of the owner of the database link

DB_LINK

VARCHAR2(12)

NOT NULL

Name of the database link

USERNAME

VARCHAR2(30)

Name of user when logging in

HOST

VARCHAR2(200)

Net8 string for connect

CREATED

DATE

NOT NULL

Creation time of the database link

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Username of the owner of the database link
DB_LINK	VARCHAR2(12)	NOT NULL	Name of the database link
USERNAME	VARCHAR2(30)		Name of user when logging in
HOST	VARCHAR2(200)		Net8 string for connect
CREATED	DATE	NOT NULL	Creation time of the database link

ALL_DEF_AUDIT_OPTS

This view contains default object-auditing options that will be applied when objects are created.

Column	Datatype	Description
ALT	VARCHAR2(3)	Auditing ALTER WHENEVER SUCCESSFUL / UNSUCCESSFUL
AUD	VARCHAR2(3)	Auditing AUDIT WHENEVER SUCCESSFUL / UNSUCCESSFUL
COM	VARCHAR2(3)	Auditing COMMENT WHENEVER SUCCESSFUL / UNSUCCESSFUL
DEL	VARCHAR2(3)	Auditing DELETE WHENEVER SUCCESSFUL / UNSUCCESSFUL
GRA	VARCHAR2(3)	Auditing GRANT WHENEVER SUCCESSFUL / UNSUCCESSFUL
IND	VARCHAR2(3)	Auditing INDEX WHENEVER SUCCESSFUL / UNSUCCESSFUL
INS	VARCHAR2(3)	Auditing INSERT WHENEVER SUCCESSFUL / UNSUCCESSFUL
LOC	VARCHAR2(3)	Auditing LOCK WHENEVER SUCCESSFUL / UNSUCCESSFUL
REN	VARCHAR2(3)	Auditing RENAME WHENEVER SUCCESSFUL / UNSUCCESSFUL
SEL	VARCHAR2(3)	Auditing SELECT WHENEVER SUCCESSFUL / UNSUCCESSFUL
UPD	VARCHAR2(3)	Auditing UPDATE WHENEVER SUCCESSFUL / UNSUCCESSFUL
REF	VARCHAR2(3)	Auditing REFERENCES WHENEVER SUCCESSFUL / UNSUCCESSFU (not used)
EXE	VARCHAR2(3)	Auditing EXECUTE WHENEVER SUCCESSFUL / UNSUCCESSFUL

ALL_DEPENDENCIES

This view lists dependencies between objects accessible to the user. Dependencies on views created without any database links are also available.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the object

NAME

VARCHAR2(30)

NOT NULL

Name of object

TYPE

VARCHAR2(12)

Type of object: PROCEDURE, PACKAGE, FUNCTION, PACKAGE BODY, TRIGGER

REFERENCED
_OWNER

VARCHAR2(30)

Owner of the parent object

REFERENCED
_NAME

VARCHAR2(64)

Type of parent object: PROCEDURE, PACKAGE, FUNCTION, PACKAGE BODY, TRIGGER

REFERENCED_TYPE

VARCHAR2(12)

Type of referenced object: PROCEDURE, PACKAGE, FUNCTION, PACKAGE BODY, TRIGGER

REFERENCED_
LINK_NAME

VARCHAR2(128)

Name of the link to the parent object (if remote)

DEPENDENCY_TYPE

VARCHAR2(4)

Two values: REF when the dependency is a REF dependency; HARD otherwise

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
NAME	VARCHAR2(30)	NOT NULL	Name of object
TYPE	VARCHAR2(12)		Type of object: PROCEDURE, PACKAGE, FUNCTION, PACKAGE BODY, TRIGGER
REFERENCED _OWNER	VARCHAR2(30)		Owner of the parent object
REFERENCED _NAME	VARCHAR2(64)		Type of parent object: PROCEDURE, PACKAGE, FUNCTION, PACKAGE BODY, TRIGGER
REFERENCED_TYPE	VARCHAR2(12)		Type of referenced object: PROCEDURE, PACKAGE, FUNCTION, PACKAGE BODY, TRIGGER
REFERENCED_ LINK_NAME	VARCHAR2(128)		Name of the link to the parent object (if remote)
DEPENDENCY_TYPE	VARCHAR2(4)		Two values: REF when the dependency is a REF dependency; HARD otherwise

ALL_DIMENSIONS

This view represents dimension objects.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the dimension

DIMENSION_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension

INVALID

VARCHAR2(1)

'Y' if this dimension is in an invalid state, else 'N'

REVISION

NUMBER

Dimension revision level

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the dimension
DIMENSION_NAME	VARCHAR2(30)	NOT NULL	Name of the dimension
INVALID	VARCHAR2(1)		'Y' if this dimension is in an invalid state, else 'N'
REVISION	NUMBER		Dimension revision level

ALL_DIM_ATTRIBUTES

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.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the dimension

DIMENSION_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension

LEVEL_NAME

VARCHAR2(30)

Name of the hierarchy level

COLUMN_NAME

VARCHAR2(30)

NOT NULL

Dependent column name

INFERRED

CHAR(1)

Whether inferred

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the dimension
DIMENSION_NAME	VARCHAR2(30)	NOT NULL	Name of the dimension
LEVEL_NAME	VARCHAR2(30)		Name of the hierarchy level
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Dependent column name
INFERRED	CHAR(1)		Whether inferred

ALL_DIM_CHILD_OF

This view represents a 1:n hierarchical relationship between a pair of levels in a dimension.

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

POSITION

NUMBER

NOT NULL

Hierarchical position within this hierarchy, position 1 being the most detailed

CHILD_LEVEL_NAME

VARCHAR2(30)

Child side of 1:n relationship

JOIN_KEY_ID

VARCHAR2(40)

If non-null, then the child joins to the parent

PARENT_LEVEL_NAME

VARCHAR2(30)

Parent side of 1:n relationship

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
POSITION	NUMBER	NOT NULL	Hierarchical position within this hierarchy, position 1 being the most detailed
CHILD_LEVEL_NAME	VARCHAR2(30)		Child side of 1:n relationship
JOIN_KEY_ID	VARCHAR2(40)		If non-null, then the child joins to the parent
PARENT_LEVEL_NAME	VARCHAR2(30)		Parent side of 1:n relationship

ALL_DIM_HIERARCHIES

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

ALL_DIM_JOIN_KEY

This view represents a join between two dimension tables. The join is always specified between a parent dimension level column and a child column.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the dimension

DIMENSION_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension

DIM_KEY_ID

NUMBER

NOT NULL

Unique within a dimension

LEVEL_NAME

VARCHAR2(30)

Name of the hierarchy level

KEY_POSITION

NUMBER

NOT NULL

Ordinal position of the key column within the level

HIERARCHY_NAME

VARCHAR2(30)

Name of the key column

CHILD_JOIN_COLUMN

VARCHAR2(30)

NOT NULL

Name of the join column

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the dimension
DIMENSION_NAME	VARCHAR2(30)	NOT NULL	Name of the dimension
DIM_KEY_ID	NUMBER	NOT NULL	Unique within a dimension
LEVEL_NAME	VARCHAR2(30)		Name of the hierarchy level
KEY_POSITION	NUMBER	NOT NULL	Ordinal position of the key column within the level
HIERARCHY_NAME	VARCHAR2(30)		Name of the key column
CHILD_JOIN_COLUMN	VARCHAR2(30)	NOT NULL	Name of the join column

ALL_DIM_LEVELS

This view represents a dimension level. All columns of a dimension level must come from the same relation.

Column Datatype

2Static Data Dictionary Views