Cloud Computing

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;

Similar Posts

Leave a Reply

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