3.248 ALL_IMMUTABLE_TABLE_COLUMNS

ALL_IMMUTABLE_TABLE_COLUMNS displays information about columns valid in each epoch in the immutable tables accessible to the current user.

Related Views

  • DBA_IMMUTABLE_TABLE_COLUMNS displays information about columns valid in each epoch in all immutable tables in the database.

  • USER_IMMUTABLE_TABLE_COLUMNS displays information about columns valid in each epoch in the immutable tables owned by the current user. This view does not display the SCHEMA_NAME column.

Column Datatype NULL Description

SCHEMA_NAME

VARCHAR2(128)

NOT NULL

Name of the schema containing the immutable table

TABLE_NAME

VARCHAR2(128)

NOT NULL

Immutable table name

EPOCH_NUMBER

NUMBER

Epoch number

COLUMN_NAME

VARCHAR2(128)

NOT NULL

Name of the column

INTERNAL_COLUMN_ID

NUMBER

NOT NULL

Internal identifier of the column

COLUMN_DATA_TYPE

VARCHAR2(106)

Data type of the column

Note:

This view is available starting with Oracle Database 23ai.

See Also: