Archives of the TeradataForum

Message Posted: Wed, 04 Jul 2012 @ 10:03:33 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi there,

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.

Mirajkar.

	<Prev	Next>		<<First	<Prev	Next>	Last>>