Database DataWarehousing (MOSC)

MOSC Banner

How to add DEFAULT/MAXVALUE partition and subpartition to an existing partitioned/subpartitioned tab

edited Oct 20, 2011 3:32AM in Database DataWarehousing (MOSC) 6 comments
Hello All,
I have the scenario where few existing partitioned tables doesn't have DEFAULT/MAXVALUE partition and subpartitions.

Can anyone please tell me the syntax to add a DEFAULT/MAXVALUE partition and subpartition to an existing partitioned table.

Is it same as adding any other partition/subpartition to an existing partitioned table?

Regards
Sree

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