Space Not Released after Truncate
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Space Not Released after Truncate

  1. #1
    Join Date
    Sep 2005
    Location
    Hyderabad
    Posts
    12

    Space Not Released after Truncate

    Hi,

    select , bytes/1024/1024 from dba_segments
    where segment_name =


    the above query gives 1668 MB. is Space occupied by the table.

    Truncate table


    didn't release the space. Its still showing 1668 MB space
    Even in the datafiles its showing as occupied.

    kssekhar
  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Code:
    truncate table my_table drop storage;
    Of course it might not release any space if your initial extents (defined by MINEXTENTS) ar ocupying it all.
    Last edited by jmodic; 09-13-2005 at 08:07 AM.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •  


    Click Here to Expand Forum to Full Width