Space not freed after table truncation
Hi,
I truncate a table (1,3 Gb according to dba_segments).
Once done, I take a look at dba_segments I've got the same number of bytes than before for that table and same size for the datafile in dba_data_files .
How do you explain that?
I performed the following operation:
export tablespace
drop tablespace including contents and datafiles
import tablespace
The size of my datafile is 200 Mb less than original one (but not 1,3 Gb less)
What's the procedure to free space from a file once space is freed from a table?
Rgds,
Frederic
Once done, I take a look at dba_segments I've got the same number of bytes than before for that table and same size for the datafile in dba_data_files .
How do you explain that?
I performed the following operation:
export tablespace
drop tablespace including contents and datafiles
import tablespace
The size of my datafile is 200 Mb less than original one (but not 1,3 Gb less)
What's the procedure to free space from a file once space is freed from a table?
Rgds,
Frederic
0