SPLIT partition and subpartition in one command

Hi,

I am doing a test to implement a partition scheme.

Successfully created partions by range and subpartitions by hash. then I dropped first partition(which holds lowest value of range). Apparently i deleted data.

Now I would like recreate that partition with subpartitions(there is no data macthing the criteria), which require i believe SPLIT PARTITION or SPLIT subparttion command, I tried with some syntax split partition with subpartitions, not working for me :(.

I appreciate if you could point me to to the right syntax/approach or reference.

thanks in advance Received on Mon Feb 25 2008 - 03:07:57 CST