Archives of the TeradataForum
Message Posted: Wed, 25 Jun 2003 @ 17:25:15 GMT
My first thought would be using the DBC.TABLESPACE to find all tables below a certain size. Since an empty table has some pace you would have to figure it out. But... You could figure out a maximum possible size for an empty table and then run collect(*) for those tables under that limit.
Second thought. Would be using statistics on the primary index to figure it out. Risk here is whether stats are up to date.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|