How can I check the last modification time of a table in Oracle?

10 months ago

Liam

1 minute

To inquire about the modification time of a table, you can use the following SQL statement:

SELECT object_name, object_type, created, last_ddl_time
FROM user_objects
WHERE object_name = 'your_table_name';

This will return the creation time (created) and last modification time (last_ddl_time) of the specified table. You can also replace user_objects with all_objects or dba_objects to query tables of other users according to your permissions and needs.