Database DataWarehousing (MOSC)

MOSC Banner

split partition against default partition of "subparition template"d table resulted in system genera

edited Oct 14, 2011 2:06AM in Database DataWarehousing (MOSC) 3 commentsAnswered ✓
Hi All
Ran "split partition" command against DEFAULT partition of a partitioned table where subpartition template is in place and the resulting partition's subparition names are system generated except the first and last subpartitions.

The first and last sub partition names of the resulting partition are derived from the template(as expected) but the ones in between are having system generated names.

FYI: Each partition is having 50 sub-partitions. This is a composite paritioned table(LIST partition-RANGE subparition). Database is 11.2.0.1(Datawarehouse env) on HP-UX Itanium(64-bit)

problem with resulting parition of both table and index.

Please throw some light on this whether this is expected behaviour or am i missing any option.

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