R
Rob Fitzpatrick
Guest
If .d3 is variable-size and you add .d4, .d3 will be fixed at its current size. You can't extend .d3 to 2 GB at that time. If having uniformly-sized extents matters to you, you can back up the database offline and then restore it with a modified structure file that resizes the extents as you like. The new structure file must match the original structure in terms of the number of areas and their characteristics, but it can have different extent sizes and number of extents within an area. "I want to create the d4 but that the d3 is 2GB and does not fix." If you mean that you want .d3 to not be a fixed extent after you add .d4, that is not possible. Only the last extent in an area can be variable-size.
Continue reading...
Continue reading...
