Methods for viewing recently modified tables in Oracle

Select Uat.table_name as table name, (select Last_ddl_time from user_objects  where object_name = Uat.table_na Me and Uat.tablespace_name= ' Jmy ') as Last_ddl_time from      user_all_tables uat ORDER by Last_ddl_time D Esc

With this statement, you can get the last modification time for all tables. (You can add the appropriate conditional expression after the SQL according to the actual situation.)

By descending the last modified time in the query results, you can see that the structure of those tables has been modified.

Methods for viewing recently modified tables in Oracle