Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

shrink tablespace after table reorg

NRAJJun 25 2014 — edited Jun 27 2014

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 25 2014
Added on Jun 25 2014
22 comments
11,189 views