JavaScript must be enabled to correctly display this content

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.

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

See Also:

“DBA_IMMUTABLE_TABLE_COLUMNS”
“USER_IMMUTABLE_TABLE_COLUMNS”