I hope there is only one method to create partition on nonempty table (pls share any there is any other method for same) :
Does this commond drop the actual index? if yes, can i create similar index on the table?
That command doesn't create a partition - it would remove any partitions created by the index being dropped. To create a partition (or, more accurately, an index over a series of partitons) you would use CREATE INDEX and specify a partition scheme as the destination data space:
In answer to your other questions, yes - the index is actually dropped and yes, you can then create a similar index.
answered Feb 22 '10 at 08:05 AM
Matt Whitfield ♦♦