using log miner to know when a partition is last modified
Hi,
I need to make a job, to move segments (tables, table partitions) to a read only tablespace as long as their data never been modified since 2 Months or more.
dba_tab_modifications doesn't have the needed info "not for old partitions", I found out that I have to use the log miner, to know exactly when the table/partition was last modified!
when there is no easier way to do it, please tell me how to do it using the log miner.
Note:
I know that this could be done depending on the App logic, and move the segment automatically to a read only tablespace. in my situation this is not possible.