NEVER SQLERROR CONTINUE NONE;
ALTER TABLE ${RDM_DB}.${TABLE_TARGET} TRUNCATE PARTITION FOR(TO_DATE('${TX_DATE}','YYYY-MM-DD')) REUSE STORAGE;
COMMIT;
ALTER TABLE ${RDM_DB}.${TABLE_TARGET} TRUNCATE PARTITION FOR(TO_DATE('${TX_DATE}','YYYY-MM-DD')) REUSE STORAGE;
COMMIT;