3.231 ALL_IMMUTABLE_ROW_VERSION_HISTORY

ALL_IMMUTABLE_ROW_VERSION_HISTORY provides a history of row versions in the immutable tables accessible to the current user.

This view is populated for an immutable table with a row version only when rows are purged from that immutable table. For each different value of the PDB_GUID and KEYCOLn_VALUE columns, information about only the youngest purged row is kept in the view.

Related Views

• DBA_IMMUTABLE_ROW_VERSION_HISTORY provides a history of row versions in all immutable tables in the database.

• USER_IMMUTABLE_ROW_VERSION_HISTORY provides a history of row versions 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	Schema containing the immutable table
TABLE_NAME	VARCHAR2(128)	NOT NULL	Name of the immutable table
ROW_VERSION_NAME	VARCHAR2(128)	NOT NULL	Name of the row version
PDB_GUID	RAW(16)		Global unique identifier of the pluggable database that inserted the row before any GoldenGate processes might have replicated the row to another database
KEYCOL1_VALUE	VARCHAR2(400)		Value of version key column 1
KEYCOL2_VALUE	VARCHAR2(400)		Value of version key column 2 Null if only one version key column is specified for the row version
KEYCOL3_VALUE	VARCHAR2(400)		Value of version key column 3 Null if only one or two version key columns are specified for the row version
VERSION_NUMBER	NUMBER		Row version number
ROW_CREATE_TIME	TIMESTAMP(6) WITH TIME ZONE		Date and time at which the row version was created
INST_ID	NUMBER		Identifier of any instance using a distributed or XA transaction to append to the row version history
TRAN_ID	VARCHAR2(22)		Identifier of any distributed transaction branch that is appending to the row version history

Note:

This view is available starting with Oracle Database 23ai.

See Also:

• "DBA_IMMUTABLE_ROW_VERSION_HISTORY"

• "USER_IMMUTABLE_ROW_VERSION_HISTORY"