3.249 ALL_IMMUTABLE_TABLE_EPOCHS

ALL_IMMUTABLE_TABLE_EPOCHS displays epoch information for the immutable tables accessible to the current user.

Related Views

  • DBA_IMMUTABLE_TABLE_EPOCHS displays epoch information for all immutable tables in the database.

  • USER_IMMUTABLE_TABLE_EPOCHS displays epoch information for 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

EPOCH_NAME

VARCHAR2(11)

Epoch name describes the reason for the epoch and is one of the following values:

  • CREATE

  • IMPORT

  • ADD COLUMN

  • DROP COLUMN

PDB_GUID

RAW(16)

Global unique identifier of the pluggable database where the immutable table epoch was created

START_TIME

TIMESTAMP(6) WITH TIME ZONE

  

Time at which the epoch was created

Note:

This view is available starting with Oracle Database 23ai.

See Also: