HIS_P201708 execute the alter table table_name truncate partition partition_name drop storage; Disk space is not released now what operation to perform?

CodePudding user response:

Disk space is not released by delete table or truncate table, because the data file size itself has not changed, you do this, only the corresponding table space available space increased

Need to resize the data file and/or drop datafile/drop TBS will release the space

CodePudding user response:

Disk space release problem not because of who you truncate table it can be released, itself a data file size no change, just table space increases,
Release space delete data file drop datafile or drop TB can be release space,

CodePudding user response:

The

refer to the original poster lzhw8811282 response:

HIS_P201708 execute the alter table table_name truncate partition partition_name drop storage; Disk space is not released now what operation to perform?

This is just the space released back into the database table space, but not release to the operating system, unless your contract file, table space or rebuild a table space,,

CodePudding user response:

Truncate after database reusable unused space, don't have to be concerned about disk space release,
If disk space is not enough, need to consider the contract documents, but are not necessarily directly contraction, may need to move tables,

CodePudding user response:

You check this view may not, because it seems truncate remember does not delete statistics, dbms_stats again the table you will see, the accuracy of the user_extends table