Archives of the TeradataForum
Message Posted: Wed, 04 Jul 2012 @ 10:03:33 GMT
We are in Teradata 13 and would like to have a list of tables from a Database which are not accessed/updated for the past 90+ days.
ObjectUseCountCollectRate field in DBS Control is not enabled.?? Hence, lastaccesstimestamp field in DBC.TABLES is not populated.
Can some one please provide a query to pull this information from either PDCRDATA or any other source to get list of tables not accessed/updated for the past 90+ days from a Database?
Thanks for your help, indeed.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|