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;
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;