Table of Contents

Search

  1. Preface
  2. Introduction
  3. Working with Enterprise Data Manager
  4. Enterprise Data Manager
  5. ILM Repository Constraints
  6. Partition Exchange Purging
  7. APIs
  8. Smart Partitioning
  9. Salesforce Accelerator
  10. SAP Application Retirement Entities
  11. Import Formats for Constraints
  12. Glossary

Enterprise Data Manager Guide

Enterprise Data Manager Guide

Step 1. Create and Configure the Interim Tables

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.

0 COMMENTS

We’d like to hear from you!