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 AI Database 26ai.

See Also:

• “DBA_IMMUTABLE_TABLE_EPOCHS”

• “USER_IMMUTABLE_TABLE_EPOCHS”