SPLIT PARTITION

[spicysudhi]

hi

i got a partitioned table. now i wanto split one of the lower partition to 2 partitions.
say my paritions like this
Part1 range values less than 10000
part2 range values less than 20000
part3 range values less than 30000
part4 range values less than 40000
part5 range values less than maxvalue

now i want to have one parition for values less than 5000 in part1a and 5000 to 10000 in part1

do i have to drop and re-create the table or anyway to do this. i saw the alter table split partition command, but not able to work it out.

regards,
sudhi

 

[spicysudhi]

i got it.

alter table myTable split parition part1(part1a values lessthan 5000, part1)

-sudhi