Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: mtime() for tables?
if you want the date which the actual data in table have been modified then you have to use trigger, on trigger per table. but you could create a generic procedure and call this procedure from all the triggers.
but if you want the date which the table was altered, then you could get
this info from data dictionary.
Tom
Gabriel Millerd <millerd_at_ns1.rli-net.net> wrote in message
news: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