Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Tables not access/updated in past 90+ days
 
From:   Mushtak Mirajkar

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016