Re: Tracking table access

marksc_at_wpmail.code3.com (Mark A. Scarton) wrote:
>
>As a utility appendage to the transformer, I need to be able to clean up the
>tablespaces as tables become dormant. I need to be able to keep track of when a
>table was last accessed (much like the Unix file system tracks access time). If
>a table of type <foo> hasn't been accessed in the last <bar> days, I can then
>drop the table.

Check out the AUDIT command in the SQL manual. It will let you track every time that a table is accessed. However you do have to clean up the audit table once in a while or it will grow forever.
Carol Fetters
cfetters_at_iac.net Received on Mon Mar 04 1996 - 00:00:00 CET