Archives of the TeradataForum
Message Posted: Wed, 23 Jan 2013 @ 12:34:27 GMT
How can we find the tables which are not accessed in 1-year? Lastaccesstimestamp in dbc.tables for a view and table differ as shown below.
So how exactly we have to proceed to find the tables(including views) which are not accessed for a year.
DatabaseName TableName LastAccessTimeStamp A TWIBMQX -table 10/12/2007 10:27 B VWIBMQX -view 7/31/2012 4:11
Thanks in Advance.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|