Dear all,
We have just finished an exercise in archiving some FI data (FI_SL_DATA, EC_PCA_ITEM, CO_ITEM).The statistics indicate data deleted to be approx. 160GB. How do one find out from which tables, most of the records were removed from?
For example, for FI_SL_DATA, there are several tables with deletion..Which table had the most records removed, so that that specific table can be targeted for a DB re-org to free up the physical space? Are these granular statistics somewhere?
Thx!
Neeta