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 08, 2019

Applies to:

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


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?


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
 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?

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