Dear Experts
12.1.0.2.0
Please help to add partition dynamically from tran_log table to tran_hist table.
SELECT partition_name PNAME, high_value
from USER_TAB_PARTITIONS
WHERE table_name = 'TRAN_LOG';
ALTER TABLE TRAN_HIST ADD PARTITION P_230521 VALUES LESS THAN (TO_DATE('2021-05-23 00:00:00', 'YYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'));
ALTER TABLE TRAN_HIST ADD PARTITION P_260521 VALUES LESS THAN (TO_DATE('2021-05-26 00:00:00', 'YYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'));
ALTER TABLE TRAN_HIST ADD PARTITION P_270521 VALUES LESS THAN (TO_DATE('2021-05-27 00:00:00', 'YYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'));
Please help me to add partition name dynamically for the respective partition in tran_hist table from tran_log table.
Expected Result
SELECT partition_name PNAME, high_value
from USER_TAB_PARTITIONS
WHERE table_name = 'TRAN_HIST';
