Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ALL_TAB_MODIFICATIONS contains not all database tables

2751995Sep 15 2014 — edited Sep 16 2014

Hi All,

I am trying to use all_tab_modifications to get last modified date of some database tables.

However there aren't all database tables in this view.

I've made sure that all the tables I want to get last modified date have Monitoring attribute ( Monitoring = Yes)

Please help me find out what else may be the reason of not containing some of my database tables in all_tab_modifications or user_tab_modifications views.

Thank you in advance.

This post has been answered by JohnWatson2 on Sep 16 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 14 2014
Added on Sep 15 2014
7 comments
3,177 views