getting the date of table's modification

From: Paolo <pscola_at_tiscalinet.it>
Date: Thu, 21 Feb 2002 16:43:05 GMT
Message-ID: <3c752385.32100958@news.tiscalinet.it>

Hi everybody,

how may I get date of table's modification ? ( modification = newly created, or just insert, delete, update)

I tried something like:

select object_name, last_ddl_time
from dba_objects
where object_name = 'MY_TABLE'

But after I modified table MY_TABLE (for example with an update) the result from the query above is the same, and nothing changed. I wonder where my mistake is.

Thanks in advance for any help, kind regards, Paolo

PS:
using Oracle 7.3.3 under AIX 4.3.1 Received on Thu Feb 21 2002 - 10:43:05 CST