Database DataWarehousing (MOSC)

MOSC Banner

change number of subpartition existing table

edited Jan 6, 2019 7:22AM in Database DataWarehousing (MOSC) 3 commentsAnswered ✓

I have tables with hash subpartitions and I want to reduce the amount of it from 32 to 8.

I am able to coalesce the existing subpartitions but any new partitions are being created with 32 partitions. What do I need to configure for new partitions to be 8?

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