1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: DBA_STREAMS_ADD_COLUMN to USER_ZONEMAPS
  4. USER_ILMPOLICIES

6.452 USER_ILMPOLICIES

USER_ILMPOLICIES displays details about Automatic Data Optimization policies owned by the user.

The view contains common details relevant to all types of Automatic Data Optimization policies, not just details relevant to the data movement-related Automatic Data Optimization policies. Its columns are the same as those in DBA_ILMPOLICIES.

Note:

Automatic Data Optimization is supported in multitenant environments starting with Oracle Database 12c Release 2 (12.2.0.1).

See Also:

"DBA_ILMPOLICIES"