Few questions on PPI

Database
Enthusiast

Few questions on PPI

Hi,

We are working on extending the PPI ranges in our tables,so i am working on automated script.For this i need to capture following information

1. Can i get partition range  & partition column information from any sytem tables?

DBC.PartitioningconstraintsVX is having textual information but not the limits or partitioning column sepaartely

2.Is there a performance hit copying data from default partition(1 day partition)  in staging table to some valid partition in target table (or) both staging and target to be partitioned for same range? plz provide a brief reason  

3. I am planning to use following syntax to extend my partiton. In the following syntax what is the significance of using "PRIMARY INDEX"? the query is working with/with out having PRIMARY INDEX

ALTER table <TABLE_NAME > MODIFY

PRIMARY INDEX

ADD RANGE BETWEEN DATE '2016-01-01' AND DATE '2025-01-01' EACH INTERVAL '1' DAY;

Any other precautions we need to take to perfom this task?

Your suggestions are much appreciated.