Archives of the TeradataForum

Message Posted: Wed, 04 Jul 2012 @ 22:54:30 GMT

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

Girish,

Thanks for your prompt response.

CREATETIMESTAMP and LASTALTERTIMESTAMP is identical with data. However LASTALTERTIMESTAMP column in DBC.TABLES will not change upon running any RUDI (DML) command.? Am I correct in my assumption?

How to obtain the list of tables which are never touched by any of the RUDI commands for 90+ days where parameter : ObjectUseCountCollectRate in DBS Control is not enabled.

Once again appreciate any help!

Mirajkar.

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