IUUC_RENAME_DB_TABLE: Copy Table A to B, Move Data to Table B, Optionally Delete A

This report can be used to first copy an existing table, along with the table content, and then optionally delete the original table. If this option is chosen, the table is actually renamed rather than copied. In any case, the table content will be only available in the target table after the processing has finished.

Alternatively you can use report IUUC_COPY_RENAME_TABLES in the table name to execute this activity. That report will consider all tables of a mass transfer for which there is an entry in table IUUC_PERF_OPTION with an entry in field TABNAME_CLONE.

Selection

The renaming can be done in two directions. If checkbox “rename back” is
NOT active, the new table will have the same name as the original table but the specified prefix will be added to the table name. On the other hand, if the checkbox is active, we have the table name without the prefix as the new table name and the table name including the prefix as original table name.

You May Also Like

Leave a Reply?