To drop or truncate partitions from multiple tables, use one interim table. Since the interim table is populated with the table_owner, table_name, and partition_name, you can insert partitions from multiple tables into this single interim table.

The following figure shows the select statement:

Note that there is only one entity step to drop or truncate the partitions. The AA_PARTITION_PKG procedure truncates or drops partitions for all tables in the interim table where purgeable_flag='Y'.

The following figure shows the entity steps: