we are periodically doing the
TRUNCATE of some large tables in database.
After that in order to release disk space we are doing the command:
alter tablespace MAXDATA reduce max
and everything works smoothly.
I have a question if for example database size iz 100 GB, and one table size is 5GB and we execute TRUNCATE command on that table, I understand that it will not release database size back to 95 GB in order to decrease it for 5 GB we must execute ALTER but will it stop the growth of database size for new data which will be populated? So does it mean that database size will be 100GB and after new 5GB data in that same table is being generated it will not trigger additional 5GB of space (105 GB) but it will keep the 100GB size.
Please provide me explanation for this.