column last_ddl_time of user_objects view gives you
the last modification date of the objects.
For a table, it's the modification of the object
(add, modify a column,...) not the modification of
the datas. For that last one, you have to create a
trigger for each table.
--
Have a nice day
Michel
Gabriel Millerd <millerd_at_ns1.rli-net.net> a écrit dans le message :
8irks3$9i2$1_at_news.powerisp.com...
>
> I would like to find out the last time a table was modified?
> Is there a method for this? I looked (describe user_tables)
> and didnt see anything evident.
>
> My current plan is to add a set of triggers (update, insert,
> delete) to each table (that i care about) that update a table
> (tablename, update_ts)
>
> Is there a way to cover more than one table with a trigger
> would be a speed up I guess. Such as table_name's from
> user_table's.
>
> Thanks for your time.
>
> ---
> Gabriel Millerd | I cannot think of a person who has grown up
> Sith Admin | and become a better person because of it.
> http://sabbat.org |
Received on Thu Jun 22 2000 - 00:00:00 CDT
