2.171 ALL_IMMUTABLE_TABLES
ALL_IMMUTABLE_TABLES
describes the immutable tables accessible to the current user.
Related Views
-
DBA_IMMUTABLE_TABLES
describes all immutable tables in the database. -
USER_IMMUTABLE_TABLES
describes the immutable tables owned by the current user. This view does not display theSCHEMA_NAME
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
The schema containing the immutable table |
|
|
|
Name of the immutable table |
|
|
|
Row retention period for the immutable table, that is, the minimum number of days a row must be retained and cannot be deleted after it is inserted into the table If the value of this column is NULL, then rows can never be deleted from the table. |
|
|
|
Indicates whether the row retention period for the immutable table is locked. Possible values:
|
|
|
|
Number of days for which the immutable table must be inactive before it can be dropped, that is, the number of days that must pass after the most recent row insertion before the table can be dropped A table with no rows can be dropped at any time, regardless of this column value. |
Note:
This view is available starting with Oracle Database release 19c, version 19.11.
See Also: