DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Space Not Released after Truncate

  1. 09-13-2005, 06:57 AM #1
    kssekhar
    kssekhar is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 09-13-2005, 07:05 AM #2
    jmodic
    jmodic is offline Super Moderator
    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 07:07 AM.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?
    Reply With Quote Reply With Quote
    3. « Previous Thread | Next Thread »

    Posting Permissions

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

    Forum Rules



    Click Here to Expand Forum to Full Width