User table modification
Dear experts,
i have a schema with 700 tables which is frequently accessed by some of the applications. when i try to check the modification details in user_TAB_modifications tables it shows only 200 tables. but the remaining 500 tables are not in the list . same output in all_tab_modifications also. i have checked the some of the tables from 500. the last analyzed happend only 2 years back. my question is , is there any rules to maintaining the tables in user_tab_modification table? like last analyzed data > 6 months/3 months tables only stored in the user_tab_modifications table? please explain on this. thanks in advance.