All Forums Database
superjuanito88 17 posts Joined 05/12
05 Jul 2012
calculate the size of a table in teradata

My question is as calculating the weight that can occupy a table in the database knowing that will add about 120 million records in a table, the insert will be done through the Multiload. What I want is to know how much space you use database before inserting the information.

ulrich 816 posts Joined 09/09
05 Jul 2012
select 
databasename, 
tablename,
sum (currentperm)/1024**3 as current_GB
from dbc.allspace 
where tablename <> 'All'
and databasename = 'yourDB'
group by 1,2
order by 1,2

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

You must sign in to leave a comment.