Enterprise Data Manager Guide

6.4.3
- 6.5.1
- 6.5 HotFix 1
- 6.5
- 6.4.4
- 6.4.3 HotFix 1

Back Next

Step 1. Create and Configure the Interim Tables

Create an interim table and add the source tables. The archive job uses partition exchange to delete records from the tables that you add to the interim table. Then, configure the default columns in the interim table.

Add columns for the table owner, table name, and partition name and define the corresponding select clauses. The partition name select clause depends on the partitioned status of the source tables in the interim table. The configuration depends on if all of the source tables in the interim table are partitioned, not partitioned, or both.

Configuring Partition Exchange

Select Clause for Partitioned Source Tables

Select Clause for Non-Partitioned Source Tables

Select Clause for Partitioned and Non-Partitioned Source Tables

Creating and Configuring the Interim Tables

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal