Oracle 视图 DBA_ILMDATAMOVEMENTPOLICIES 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_ILMDATAMOVEMENTPOLICIES用于显示与数据移动策略相关的信息，具体包括：策略名称、创建者、创建日期、上次修改者和上次修改日期等。这个视图可以帮助DBA及开发者在数据库中管理并监控数据移动策略。
要使用这个视图，首先需要在数据库中创建数据移动策略，然后使用SELECT语句可以查询视图中的相关数据，例如可以查询出所有策略的名称、创建日期以及上次修改日期，类似的也可以查询其它的信息：
SELECT POLICY_NAME, CREATED_BY, CREATED_DATE, LAST_MODIFIED_BY, LAST_MODIFIED_DATE
FROM 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:
“USER_ILMDATAMOVEMENTPOLICIES”
