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
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?