Re: ADO/ILM policy

Posted by Roshan on Nov 09, 2018; 11:49am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ADO-ILM-policy-tp6926p6932.html

The blog below is also helpful. It clarifies my requirement
https://blogs.oracle.com/dbstorage/ado-automating-storage-tiering-for-information-lifecycle-management

"when a tablespace reaches the used threshold (85%) defined by the user, the
database will automatically move the coldest table/partition(s) in the
tablespace to the target tablespace until the tablespace quota has at least 25
percent free. Of course this only applies to tables and partitions that have a
"TIER TO" ADO policy defined. "

The "TIER TO" policy can be implemented as shown below
http://blog.sqlora.com/en/ilm-storage-tiering/