1 2 Previous Next 22 Replies Latest reply on Jun 27, 2014 4:12 PM by Jonathan Lewis

    shrink tablespace after table reorg

    NRAJ

      Hello,

       

      I did the table reorg of one table after moving major data to cloud.  Table size Before - 120G / After 150 MB. Oracle SE 11203.

       

      Now from the tablespace level I see Total Free MB is 182825.953, but I cannot shrink at the tablespace level,

       

      TABLESPACE_NAME Used Size MB           Max Size Mb Total Used MB Total Free MB    Used Percentage

      ------------------------------ ------------ ----------- ------------- ------------- --------------------------------------------------------

      XXX                                        210391.922 262143.875 79317.9219          182825.953           30

       

      When I query datafile for resize it shows only 4G can be gained.

       

      FILE_NAME Smallest Size Poss.  Current Size    Poss. Savings

      ----------------- -------- ------       -----------     -----------

      XXXXX                       20,865                 23,000         2,135

      XXXXX                       21,570                 22,528           958

      XXXXX                          129                      1,024           895

      XXXXX                       32,352                 32,768           416

       

       

      Could you please let me know the way to shrink and get the 178G ?

       

      Thanks,

      Raju

        1 2 Previous Next