Table of Contents

Search

  1. Preface
  2. Introduction to Enterprise Data Manager
  3. Enterprise Data Manager
  4. ILM Repository Constraints
  5. Partition Exchange Purging
  6. APIs
  7. Salesforce Accelerator
  8. Appendix A: SAP Application Retirement Entities
  9. Appendix B: Import Formats for Constraints
  10. Appendix C: Glossary

Enterprise Data Manager Guide

Enterprise Data Manager Guide

Creating and Configuring the Interim Tables

Creating and Configuring the Interim Tables

Before you begin, identify the tables that you want to delete data from by using partition exchange. In the corresponding entities, create interim tables and add the tables. Then, configure the interim table.
  1. Access the entity that includes the tables.
  2. Create an interim table.
    You may want to indicate in the description that the interim table is for partition exchange.
  3. In the
    Tables
    tab, add the tables.
  4. In the
    Default Columns
    tab, add the following entries for the table owner, table name, and partition name:
    Order
    Name
    Type
    Length
    Select Clause
    1
    TABLE_OWNER
    VARCHAR2
    50
    A.TABLE_OWNER
    2
    TABLE_NAME
    VARCHAR2
    50
    A.TABLE_NAME
    3
    PARTITION_NAME
    VARCHAR2
    50
    A.PARTITION_NAME
  5. Configure the select clause for the partition name.
    The configuration depends on if all of the source tables in the interim table are partitioned, not partitioned, or both. If the source table is partitioned and you archive data from multiple partitions in the table, then list each partition from which you archive data.
  6. Save the interim table.

0 COMMENTS

We’d like to hear from you!