Database Administration (MOSC)

MOSC Banner

truncate table

edited May 1, 2009 8:53AM in Database Administration (MOSC) 1 commentAnswered
 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

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