split partition against default partition of "subparition template"d table resulted in system genera
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.
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.
0