Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

uniform extent size issues

Ed CharterAug 27 2018 — edited Aug 28 2018

Hi All,

I have a tablespace created with the uniform extent size set to 128M. This was created long time back, and there are about 40 partitioned tables created in this tablespace. Each partition of a table is using 128M Initial extent even though there is just one record (size 2k). is there a way to alter the tablespace "uniform extent size", and also change the Initial extent size of the table partitions ? I am using Oracle 11.2.0.4. Please advise.

Thanks

This post has been answered by Jonathan Lewis on Aug 28 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 25 2018

Added on Aug 27 2018

#general-database-discussions

5 comments

556 views