I came across a requirement where I need to find when a table on the schema was modified. I am posting the solution here so as my other fellow programmers can get the idea.
SELECT * FROM all_objects
WHERE owner = 'object_owner
AND object_name = 'object_name
The column "CREATED" tells you when the object was created. The column "LAST_DDL_TIME" tells you when the last DDL was performed against the object.
Example:
SELECT created
FROM all_objects
WHERE object_name = 'my_table'
AND owner = 'sysdba'
AND object_type = 'TABLE'
It will tell you when a table was created.
The odds are good, but the goods are odd. -S
