Database Administration (MOSC)

MOSC Banner

How to shrink or reuse allocated space of xmltype object relational tables

Oracle Enterprise 19.14.0.0

we are trying to shrink an object relational xmltype table after deleting rows in the main table to reuse the space used by the nested table segments.

There is no error message when issuing "alter table xml_table shrink" or "shrink cascade" or "shrink compact" (after enabling row movement) but the objects won't release allocated space an seemingly won't reuse the space but only get larger. 

Space is only reclaimed when we use a "alter table move" statement but since one cannot use "online" with lobs, this operation is time intensive and because of the size of the table won't and in the maintenance window. 

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