>> If i drop a partition, should this also drop the corresponding partition index if the Global indexing is using?

There is no corresponding index partition for the table partition unless you have used local partitioning of the index.

>>If a new parition is added, will this create a new partition index automatically, with the same name as new tabl partition?

No -- that happens with local index partitioning.


why did you choose to use global partitioning instead of local?