Skip to Main Content
Forums

SQL & PL/SQL

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!

List of recently updated tables in oracle.

723860Nov 6 2009 — edited Nov 9 2009
I am trying to search for some query that would help me to get the list of recently updated tables.

I mean if I perform some action on oracle forms it would update/insert record in many of the oracle tables in the backend. I just need to get the list of tables on which insert/update/create query is performed , not the one with select queried table.

I searched in 'TAB' and 'ALL_TABLES' table but there is no last_update flag column available.

Appreciate your help!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 7 2009
Added on Nov 6 2009
#list, #oracle, #query, #table, #update
10 comments
4,298 views