Database Administration (MOSC)

MOSC Banner

Space not freed after table truncation

edited Feb 17, 2010 7:03AM in Database Administration (MOSC) 33 commentsAnswered ✓
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center