To find the recent modified date time of the object in oracle can be find out by using the following scripts. If we keep only the schema restriction, it can pull out all the tables from that owner or schema (Date and Time of Most Recent Change To a Row In Oracle Table)
Many of the technical experts trying to find out when the table lastly modified for several reasons. This below script is a handy tool for them to assist.
for r in (select OBJECT_NAME from all_objects where OBJECT_TYPE='TABLE'
and OBJECT_NAME like 'TABLENAME%' -- ANY OBJECT NAME CAN BE WRITTEN HERE
ORDER BY OBJECT_NAME)
tblname := R.OBJECT_NAME;
strsql := 'select SCN_TO_TIMESTAMP(MAX(ORA_ROWSCN)) FROM OWNERNAME.' || tblname;
execute immediate strsql into v_count;
DBMS_OUTPUT.PUT_LINE(tblname || ',' || v_count);
when others then