SELECT 'ALTER TABLE I9_B_RETAIL_LOAN ADD PARTITION'|| PARTITION_name || ' VALUES ('''||SUBSTR(PARTITION_name,2, 4)||'-'||SUBSTR(PARTITION_name,6, 2)||'-'||SUBSTR(PARTITION_name,8, 2)||''') tablespace TS_IFRS9_DATA;' FROM USER_TAB_PARTITIONS
WHERE TABLE_NAME = UPPER('表名')