truncate table
i'm running db 9.2.0.8. and i'm finding a curious behaviour in TRUNCATE TABLE. it seems this SQL command does removed all the rows - as expected. however, the database extents in which the data was stored is not restored back to the database (DBA_SEGMENTS.EXTENTS) adding DROP STORAGE doesn't seem to help either. and to make matters MUCH worse, this seem intermittent ! sometimes it actually DOES recover the space! is there a good, comprehensive piece of documentation out there that fully explains TRUNCATE TABLE, all of it's idiocracies, and it's changes from one version to the next ?
help !
greg
0