PROVE IT !!If you know it then PROVE IT !! Skill Proficiency Test

How to find the space used by a particular database in Teradata?

24) How to find the space used by a particular database in Teradata?

Answer >

SEL DATABASENAME,TABLENAME,SUM(CURRENTPERM)/(1024*1024*1024)

FROM DBC.TABLESIZE

WHERE TABLENAME=’xxxxxxx’

GROUP BY 1,2;

Add a Comment

Your email address will not be published. Required fields are marked *