USER_ILMOBJECTS displays all the Automatic Data Optimization policies and objects for a user. Many objects inherit policies via their parent objects or because they were created in a particular tablespace. This view provides a mapping between the policies and objects and indicates whether a policy is inherited by an object or is directly specified on it. Its columns are the same as those in DBA_ILMOBJECTS.


Automatic Data Optimization is not supported with a CDB.

See Also: