Tracking table access

I am working on a transformation agent based upon using an Oracle database recipient. It receives messages in various formats and needs to store the values in relational form.

The essence of the tool is to create table definitions on the fly if a suitable table doesn't already exist, then populate tuples of the table with the contents of the newly received messages. These tables will be read-only to all but the transform agent, since the translation to relational form is solely for manipulation by SQL-based products (SAS, SPSS, Access, etc.).

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.

Any suggestions for how to track access times? Please e-mail to 'mascarton_at_wpmail.code3.com'. Thanks!!!

Mark A. Scarton, ABD
CompUtah!, Park City, Utah USA
Home: 801.565.9835
Office: 801.265-4612 Received on Wed Feb 21 1996 - 00:00:00 CET