My Oracle Support Banner

How To Delete The Contents Of The ODI Work Repository Tables Called SNP_EXP_TXT And SNP_EXP_TXT_HEADER? (Doc ID 553031.1)

Last updated on FEBRUARY 03, 2022

Applies to:

Oracle Data Integrator - Version 10.1.3.2.0 to 11.1.1.9.99 [Release 10gR3 to 11gR1]
Information in this document applies to any platform.

Goal

When performing a manual delete in Oracle Data Integrator (ODI) Operator or using the OdiPurgeLog tool, it appears that the number of records in the SNP_EXP_TXT (or SNP_EXP_TXT_HEADER) table has only been marginally reduced.

How then, is it possible to delete the contents of SNP_EXP_TXT and SNP_EXP_TXT_HEADER tables to avoid saturation?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
 The SNP_EXP_TXT and SNP_EXP_TXT_HEADER tables are used to store...
 How to delete what is related to executions?
 How to delete what is related to Scenario definitions?
 How to delete what is related to Text Type Variables?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.