Database Administration (MOSC)

MOSC Banner

Initial extent size when converting to partitioned table

Working in an Oracle 19c database on Linux x86/64 trying to convert non-partitioned table to partitioned table.

Since Oracle12, alter table modify partition has been available to convert non-partitioned tables to partitioned tables. I have a non-partitioned table that has the initial_extent size set to 544MB. This is way too large. The actual first extent is 8MB.

When I use the alter table modify partition, I end up with 90 partitions all with an initial extent of 544MB. this results in the tripling of the size of the table. Many partitions are 90% plus empty.

Question is this. How to set initial partition extent size to a reasonable value during this process?

Tagged:

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