All Forums Database
Abdulaziz 10 posts Joined 10/11
06 Aug 2015
Table occupying space without any rows

Hi Experts,
My loads are failing because the database is running out of space. When I checked the table size of the table being loaded it shows it is occupying 90GB(including the skew). Whereas the table has zero records in it. Can you please let me know what exactly is causing the table to occupy 90GB of space even when it has no  rows in it.
Thanks and Regards
Abdul

Regards, Abdulaziz Shaikh
Abdulaziz 10 posts Joined 10/11
06 Aug 2015

This are the latest findings...
Even when I truncate and reload the same data the table space keeps on increasing with every run. I am seeing that the table is not releasing the space. 
In my knowlege if the data is deleted from table the tablesize goes down to zero. Has anything changed recently in any of the Teradata release?
 

Regards,
Abdulaziz Shaikh

dnoeth 4628 posts Joined 11/04
06 Aug 2015

This might be due to an active Online Archive on that table, check using dbc.ArchiveLoggingObjsV.
Either run an ArcMain job with LOGGING ONLINE ARCHIVE OFF.
Or drop & recreate the table.
And then find out why this was not switched off in the matching backup job :-)

Dieter

Abdulaziz 10 posts Joined 10/11
11 Aug 2015

Thanks Dieter. The suggestion worked.

Regards,
Abdulaziz Shaikh

You must sign in to leave a comment.