Len Kramer
New Member
I have a database with 14 fixed extents of 2Gb and 1 variable overflow extent. The variable extent is getting used now so I want to add some new extents.
But when I add a new variable extent, the current one will be made 'fixed' with the current size.
Is there a way to make this previous variable extent fixed with a size of 2Gb, like all other fixed size extents, instead of the current size without the need to resolve to a dump and load?
Version is 11.2
But when I add a new variable extent, the current one will be made 'fixed' with the current size.
Is there a way to make this previous variable extent fixed with a size of 2Gb, like all other fixed size extents, instead of the current size without the need to resolve to a dump and load?
Version is 11.2
Last edited: