5.97 DBA_ILMDATAMOVEMENTPOLICIES
DBA_ILMDATAMOVEMENTPOLICIES
contains information specific to data movement-related attributes of an Automatic Data Optimization policy in a database.
Related View
USER_ILMDATAMOVEMENTPOLICIES
contains information specific to data movement-related attributes of an Automatic Data Optimization policy for a user.
Note:
Automatic Data Optimization is supported in Oracle Database 12c Release 2 multitenant environments.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
The Automatic Data Optimization policy name is autogenerated |
|
|
|
Type of data movement action performed by the Automatic Data Optimization policy:
|
|
|
|
Identifies the scope of the Automatic Data Optimization policy:
|
|
|
|
Compression level to move selected rows or the entire segment to, for a compression Automatic Data Optimization policy |
|
|
|
Tablespace to move the object to, for a storage Automatic Data Optimization policy |
|
|
|
This column is only valid for storage tiering policies, and indicates whether the storage tiering policy was specified with a In other words, this column indicates whether the tablespace the object is being moved to will be made READ ONLY after the movement. |
|
|
|
Column on which the condition for the policy is based. Possible values:
|
|
|
|
Number of days in the condition for the policy |
|
|
|
Optional function that evaluates the precondition on the policy |
|
|
|
Storage tier on which the policy is specified |
|
|
|
Text of the action executed by the policy |
|
|
|
Storage tier where the data is placed after the policy is executed |
See Also: