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”
编辑：一起学习网
标签：视图,策略,数据,数据库中,创建日期