Skip to Main Content

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!

How to get the last DML Operation time on all the tables of a Schema

Satyam ReddyAug 24 2021

Team,
Let's consider the scott schema for our reference.
Can someone please share a query where in we can get the last DML operation performed on all the tables of scott schema.
Please do let me know if we can use ALL_TAB_MODIFICATIONS table's Timestamp column.
In case yes, Please let us know in case of any restrictions on using this table.

Thank you !!

Comments
Post Details
Added on Aug 24 2021
7 comments
11,243 views