Database Administration (MOSC)

MOSC Banner

tablespace shrink

edited Nov 6, 2019 4:04AM in Database Administration (MOSC) 5 commentsAnswered ✓

Hi,

I have a tablespace that is proving a challenge to reclaim disk from!!

How do I go about reclaiming the empty space below? I was thinking moving the largest object to a new tablespace would produce a lot of datafiles with zero extents used, dropping those datafiles. The large object moved accounted for 90% of the 10T now free. (dropped a few partitions)

TABLESPACE                            MAX_SIZE_GB   USED_SIZE_GB  TOTAL_USED_GB  Total Free GB Used Percentage

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

HCP_DATA_COVERAGE                     2,240.0        2,070.1                      1,325.1                    914.9                 59

HCP_DATA                                         19,104.0       17,992.2                      8,349.2                10,754.8                44

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

sum                                                     21,344.0       20,062.3                     9,674.3                 11,669.7

I'm hoping there is some other option than to move all the remaining objects as we are short on disk.

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